When you select to perform an Object Level Recovery Restore, the Restore Object Level Recovery dialog box 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, and Microsoft Azure Cloud 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 Backup does not support Object Level Recovery options with compressed and encrypted native backups from SQL Server 2014 and higher.
For more information about recovering objects using SQL Virtual Database, click here.