SQL Object Level Recovery Pro^™

Now included in SQL Backup Pro: Recover database objects from SQL Backup (.sqb) backups

Restore individual objects instead of full database backups
Gain time: restoring objects is much faster than restoring a full database backup
Save space: restored objects take up less space than restored databases
Comparison engine technology of industry-leading SQL Compare and SQL Data Compare
SQL Server 2008 compatible

What is SQL Object Level Recovery Pro?

SQL Object Level Recovery Pro enables you to recover either a single object or a selection of database objects from a (.sqb) backup file created with Red Gate SQL Backup Pro. You can restore individual objects from your .sqb backup files to a database on a server that is licensed with SQL Backup Pro. You can also recover objects from differential backups if original full and differential backups exist. To see how SQL Object Level Recovery Pro works in detail, take a look at the walk-through.

SQL Object Level Recovery Pro can recover individual objects from .sqb SQL Server 2008 backups, if the SQL Server 2008 database objects are not encrypted. This is an advantage over some competing object level recovery solutions that do not offer this support.

SQL Object Level Recovery Pro supports the recovery of:		SQL Object Level Recovery Pro does not support:
Tables Functions Stored procedures Views User-defined types	Objects from log backups Objects from filegroup backups Foreign key contraints

Why recover objects instead of full databases?

In a disaster recovery scenario, time is short. If you only want to recover, for example, a single table from a backup, restoring an entire backup can potentially take hours of time and consume considerable disk space. Performing object level recovery and inserting the object(s) into the relevant database offers the advantage of potentially huge time and disk-space savings.

If you want to double-check that the integrity of your data is not compromised by restoring a single object into a database, Red Gate SQL Compare Pro and SQL Data Compare Pro let you compare and synchronize the schema and contents of the two databases you are restoring from and to. SQL Compare Pro, SQL Data Compare Pro and SQL Backup Pro are available as part of the SQL Toolbelt, offering you a substantial cost saving over the price of purchasing tools individually.

Want to try SQL Object Level Recovery Pro?

SQL Object Level Recovery Pro is a feature of SQL Backup Pro. If you want to give it a try, download a free, fully-functional, 14-day trial of SQL Backup Pro. If you have any questions, please call or email backup.info@red-gate.com at any time with your questions. We will be very happy to help.