Object level recovery
Published 13 February 2013
Sometimes you may need to restore individual database objects rather than a complete backup. For example, a user may have accidentally dropped a lookup table, or deleted important data from a production database.
To restore the table from a backup, you would normally have to restore the entire database to an appropriate test server, and then produce a table creation script and data insert statements to recreate the table in the production database. For large databases, the full restore may take a long time, and could require a lot of free disk space on the test server.
SQL Object Level Recovery Pro (included with SQL Backup Pro) enables you to extract individual database objects from a backup file, and recover them to a database of your choice.
By recovering only the objects you specify, SQL Object Level Recovery Pro can save you a considerable amount of time when compared to restoring a full backup. You can also save space, as you do not need to restore a complete database.
SQL Object Level Recovery Pro temporarily stores a recovery script on the computer it runs on, for which some disk space is required. The recovery script contains the SQL needed to recreate only those database objects that you select for recovery. If you have chosen to recover tables, this includes the table data.