When you select to perform an Object Level Recovery Restore, the Object Level Recovery dialog box opens indicating that only SQL Safe (.safe) backups sets can be used with this option.

The Restore Wizard opens with the following options:

  • Target - in this section, you can select the SQL Server instance where you want to restore. Go to Selecting the target instance for restore for more detailed information. 
  • Databases - specify the databases you want to restore and the general location of the corresponding archive files. Go to Selecting the Databases for restore for more detailed information. Take into account that Tivoli Store Manager, Amazon S3 Cloud, or Microsoft Azure Storage are not available for Object Level Recovery. 

  • Backup Sets -  choose which backup sets you want to use for restore. Go to Selecting the Backup set for restore for more detailed information. 
  • Temporary Location - select where to restore virtual databases. Type the path in Temporary Location and select your instance from the drop-down options. 
  • Database Objects - for each Database Virtual Object, specify in Restore As the name with which you want to restore your database virtual object and type your File location. You can also select the database objects to restore separately, such as tables, stored procedures, functions, views, schemas, etc. 
  • Finish - before clicking Finish to proceed with your restore operation, you can go to previous sections to review and make any necessary modifications. 

SQL Safe 8.4 does not support Object Level Recovery or Instant Restore for native backup. When you select this option, the wizard lists all the Safe (.safe) backup sets.

For more information about recovering objects using SQL Virtual Database, click here.

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

  • No labels