Using SQL Object Level Recovery Native

This topic describes the basic steps to recover objects from a backup file using SQL Object Level Recovery Native, including tips to help you get the most from the application.

SQL Object Level Recovery Native is licensed per user. You do not need to install any software on the SQL Server that you recover objects to.

You recover objects in four steps:

Select a backup source
Select objects to recover
Select a destination database
Recover the objects

1. Select a backup source

you can add full backup files or differential backup files (SQL Server MTF files only; these usually have a .bak extension)
If you add a differential backup file, you will also need to add the related full backup file.
for backups that are split across several files, you must add every file from the backup set.
if there are problems validating the file or backup, is displayed in the OK column; select the file or backup to see a detailed error message in the lower pane

2. Select objects to recover

SQL Object Level Recovery Native does not automatically check for dependencies between objects, but objects are recovered in an order that reduces the possibility of errors caused by missing dependents.
Depending on the contents of the destination database, you may have to select several objects to ensure that the necessary object dependencies are maintained.
the Data tab (available for table objects only) shows the first 100 rows of data in a table
Some types of data (for example, varchar and nvarchar) may not be shown if it is too large to display.
View Recovery Script displays a complete object and data recovery script for the objects you have selected; you can edit this script if required, then save it and run it on the target database to restore the objects
SQL Object Level Recovery Native does not support all possible arguments of the CREATE TABLE statement
For more information, see Limitations.

3. Select a destination database

you can restore objects to SQL Server 2000, SQL Server 2005, or SQL Server 2008 databases
You cannot restore objects to a version of SQL Server that is earlier than the version of SQL Server used to create the backup.
the destination database must be open, and in a suitable state to create recovered objects
For example, a database that is currently being restored cannot be used as a destination database.
you must have appropriate security permissions to create objects in the destination database

4. Recover the objects

when you click Recover, the Recovering Objects dialog shows the status of each object you selected for recovery
objects marked with could not be recovered. Select an object in the Progress list to display a detailed error message for that object in the Messages pane.
SQL Object Level Recovery Native will not alter or overwrite existing objects in the destination database
See Limitations for more information.

Was this article helpful?

Search support