Tuesday, April 21, 2015

Kroll Ontrack survey reveals that nearly 90 percent of SQL restore requests are due to human error

Ontrack® PowerControls™ for SQL restores tables in seconds, including from compressed backups

MINNEAPOLIS, April 21, 2015 – An overwhelming majority (87 percent) of SQL restore events have their roots in human error, adding up to hours of recovery time for SQL database administrators (DBA), this just one of several takeaways from a recent survey of SQL DBAs and developers by Kroll Ontrack, the leading provider of data recovery and ediscovery products and services. Whether due to accidental deletion (35 percent), development errors (28 percent), erroneous overwrites (24 percent) or system crashes (13 percent), time spent restoring SQL databases is time taken away from addressing critical DBA responsibilities.

Further, Kroll Ontrack research demonstrates that respondents field nearly twice as many requests to restore data to development and test environments compared to production environments – a logical outcome considering that developers are continually trying out new things in development environments, making them highly iterative and therefore less stable. In fact, on a monthly basis, 50 percent of respondents handle between one and five development and test restore requests, nearly 20 percent handle between six and ten requests, and 15 percent tackle more than ten requests each month. With previous Kroll Ontrack survey results reporting database table restorations taking upwards of an hour to complete, leveraging efficient technologies to reduce restore time is key to saving time and money.

“It’s no secret that data housed within SQL databases is critically important to the business success of an organization,” says Tom McCaffrey, director of enterprise solutions at Kroll Ontrack. “As such, any disruption to the database is inherently costly, putting pressure on DBAs to execute an efficient recovery solution yesterday. Ontrack PowerControls for SQL gives DBAs the ability to granularly restore SQL tables in seconds, not hours, without having to restore the entire database or use SQL to read the backups.”

Addressing Compressed Backups

In its most recent release, Ontrack PowerControls for SQL 8.1 adds functionality to support compressed Microsoft SQL Server® backups in addition to native backups and storage tier snapshots, giving IT administrators the ability to open and restore tables from compressed backups.

“Compressed backups became widely available with SQL Server 2008 R2 and are in use by the majority of organizations”, says Sascha Lorenz, Microsoft MVP. “In addition to the apparent benefit of storage space reduction, compressed backups have gained in popularity because backups can be done faster and restore time is quicker from the backup.”

Ontrack PowerControls additionally empowers DBAs to better address regular SQL table restoration through:

  • Drag and drop functionality: Easily restore single tables from native SQL backups or storage tier snapshots to the desired environment, eliminating the need to restore the entire database
  • Pre-restore validation: Preview table content to verify the table data is correct prior to performing the restore
  • Streamlined process: Eliminate the need for T-SQL or PowerShell scripting when copying a table from a backup or snapshot

Ontrack PowerControls supports Microsoft SQL Server 2005, 2008, 2008 R2, 2012 and 2014 and does not require a unique or proprietary backup format to perform the restore. For more information about Ontrack PowerControls for SQL and to download a free trial, visit https://www.krollontrack.com/software/powercontrols/trialdownload/.

About Kroll Ontrack Inc.
Kroll Ontrack provides technology-driven services and software to help legal, corporate and government entities as well as consumers manage, recover, search, analyze, and produce data efficiently and cost-effectively. In addition to its award-winning suite of software, Kroll Ontrack provides data recovery, data destruction, electronic discovery and document review. For more information about Kroll Ontrack and its offerings please visit: www.krollontrack.com or follow @KrollOntrack on Twitter.


Media Contact: Kristin Husom, 952-516-3781, khusom@krollontrack.com