The last few months, I’ve been writing about a common problem that exists in the DBA world: the request to restore a SQL table from a backup or storage-tier snapshots. Whether it is tackled by a SQL DBA, Developer, Consultant or “Jack of All Trades,” who supports SQL in addition to many other IT roles, these requests take time. Why? Because the native restore process, which is the most common way this issue is addressed, requires the entire database to be restored and the SQL Server to be present during the restore.
Hours of time are not the only thing at stake for the DBA. Because SQL is the foundation for many enterprise applications, we are usually talking about critical revenue application downtime, which can cost a company hundreds of thousands of pounds. Let’s look at what one small internal application restore request can cost an organisation. Here are the factors:
- 1 restore per month
- 1 hour spent finding the available storage and SQL server resources to set up the restore
- 1 hour to perform the full database restore
- Approximately £15 an hour as the average labour rate for a DBA in the UK
- £1,000 per hour cost of application downtime
Total: £101,562.50 per year
Have no fear. I’m thrilled to announce that a better, faster option is near! With an amazing group of Kroll Ontrack developers and input and testing from nearly 100 DBAs internationally (thank you Alphas, PASS Minnesota and PASS worldwide!), we have developed a new granular search and restoration tool for Microsoft SQL Server – Ontrack® PowerControls™ for SQL Server. DBAs can now restore SQL tables without having to restore the entire database or use SQL to read the backups. This literally cuts the time spent restoring tables from hours to minutes.
Using Ontrack PowerControls for SQL, DBAs will no longer have to restore a database to get back one table. With simple drag and drop functionality, single tables can be restored from native SQL backups or storage tier/SAN snapshots to the desired environment. The SQL table content can also be previewed to verify the correct table is being restored prior to actually doing the work.
Ontrack PowerControls for SQL is a win-win for DBAs and the businesses they work for. A DBA can now say “yes” to restore and table copy requests they previously had to turn away, and they can do them in a fraction of the time, giving them the ability to get back to their planned activities. The business can reduce application downtime, do more thorough testing and development, and spend more quality time on strategic projects.
Get your free trial copy, available this week.