This walkthrough will show you:

• How to work with OLR
• Selection of .sqb backup files and objects
• Recovery of objects

Step 1: Start SQL Object Level Recovery Pro

Right-click a SQL Server instance in the SQL Backup Pro GUI and select Object Level Recovery to start SQL Object Level Recovery Pro.

Step 2: Specify the destination database

In the Select Destination Database dialog, specify the database you want to restore the object to.

Step 3: Select the backup source

Click Select backup source (next to the green arrow). The Select Backup Source dialog is displayed.

Next, click Add Files to browse for SQL Backup (.sqb) backup files. If you have encrypted your backup, enter the password and click Decrypt.

Now, in the Available backups pane, choose the backup you want to recover objects from. Then click OK.

Step 4: Choose and preview objects

The objects available in the backup source you selected are now listed in the Objects pane. You can preview the schema for any object (and preview the data for table objects), by highlighting the object in the Objects pane. You can also view the recovery script.

Select the objects you want to recover, and click Recover Objects to view a summary of the objects that will be recovered.

Step 5: View a summary and recover objects

The summary shows you a list of the objects that will be recovered and to which SQL Server and database these objects will be restored. Click Recover to start recovering objects.

Step 6: Check the status of the object recovery operation

A progress window shows you the status of the object recovery operation.

If an object cannot be restored, you can select the object in the progress window to see a more detailed error message.