Red Gate logo

Walkthrough

This walkthrough of SQL Object Level Recovery Native will show you:

  • How to recover individual database objects from native SQL Server backup files
  • How to select backup files and objects
  • How to view the status of your object recovery

Step 1: Select the backup source

Select the backup source

Step 2: Add backup files

Add backup files

Click Add Files to browse for backup files. You can select several backup files at once.

SQL Object Level Recovery Native is compatible with SQL Server 2008, 2005, and 2000 .bak backup files.

Each backup file you add is checked for validity. If a backup file is invalid, you can click on the file name to display a detailed error message.

When you add a valid backup file, details for the associated backups are listed in the Available backups pane. You may need to add more backup files if associated backups are split across multiple files, or are differential backups.

If the backup file you have selected is encrypted, enter the password to decrypt it.

Click OK to proceed to the next step.

Step 3: Select the objects you want to recover

Select the objects you want to recover

Tick the box next to the object(s) you want to recover. Click Recover Objects to start the recovery of the selected object(s).

 

Step 4: Select the destination server and database

Select the destination server database

Step 5: View the status of your object recovery in the status window

View the status of your object recovery in the status window

A status window informs you about the outcome of your object recovery. If there are any problems, select the progress message to view more details in the Messages pane.

Click Close to finish.