News
Kroll Ontrack fundamentally changes SQL Server table restores with the launch of Ontrack PowerControls for SQL
November 2014 by Marc Jacob
The company announced it has expanded its award-winning Ontrack® PowerControls™ suite to include a granular search and restoration tool for Microsoft® SQL Server®. The expansion is in direct response to feedback from customers who say restoring SQL tables from backups or storage-tier snapshots is a frequent request that can easily add hours of disruption per day. The new capabilities can drastically cut the time spent restoring these tables, literally from hours to minutes.
Kroll Ontrack research revealed that 64 per cent of the DBAs surveyed report regular SQL restore events per month, which are the result of dropped tables, missing row or column data, or table data that is needed for development or analysis. Thirty-nine per cent report between one and five SQL restore requests a month, and a further 25 per cent cite more than six restore requests per month. When asked how long it typically takes to restore a table from a SQL Server database, 52 per cent report more than an hour.
Specifically, Ontrack PowerControls for SQL allows DBAs to quickly and easily address regular SQL table restoration requests through the ability to:
· Drag and drop single tables from native SQL backups or storage tier snapshots to the desired environment, eliminating the need for to restore the entire database
· Preview table content to verify the point-in-time version of the table prior to performing the restore
· Eliminate the need for T-SQL or PowerShell scripting when restoring a table
Ontrack PowerControls supports SQL 2008 R2 and SQL 2012 and does not require a unique or proprietary backup format to perform the restore. For more information about Ontrack PowerControls for SQL contact us or pre-register for a free trial. Further, to see how full database restores are impacting your company, see the Enterprise Cost of Full Database Restores Calculator.
