Walkthrough: Object Level Recovery Pro
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
- Step 2: Specify the destination database
- Step 3: Select the backup source
- Step 4: Choose and preview objects
- Step 5: View a summary and recover objects
- Step 6: Check the status of the object recovery operation
Right-click a SQL Server instance in the SQL Backup Pro GUI and select Object Level Recovery to start SQL Object Level Recovery Pro.
In the Select Destination Database dialog, specify the database you want to restore the object to.
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.
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.
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.
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.
Try a 14-day fully functional free trial of SQL Backup Pro.
Find out more: