Human error: People to blame for nine in ten SQL restore requests.
New research from Kroll Ontracki, highlights that an overwhelming majority (87 per cent) of SQL restore events have their roots in human error.
The most common human error is accidental deletion accounting for one in three (35 per cent) restore requests. This is followed by development errors (28 per cent), erroneous overwrites (24 per cent) and system crashes (13 per cent) adding hours of recovery time for SQL database administrators (DBAs).
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. This is 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 per cent of respondents handle between one and five development and test restore requests, nearly 20 per cent handle between six and ten requests, and 15 per cent 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 organisation," says Paul Le Messurier, Programme and Operations Manager 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."
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 www.krollontrack.co.uk
|Printer friendly Cite/link Email Feedback|
|Title Annotation:||Research Updates|
|Date:||May 1, 2015|
|Previous Article:||Tackling the fastest and most powerful computing systems on the planet: future computers with millions of processors.|
|Next Article:||IBM scientists achieve critical steps to building first practical quantum computer: two milestones overcome obstacles to a working system IBM.|