Page History
When you select to perform an Object Level Recovery Restorea Restore to your Database Files, the Restore Object Level Recovery dialog box SQL Safe Database File 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 select 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 restoreselect databases for more detailed information.
Note .
- Backup Sets - choose which backup sets you want to use for restore. Go to selecting select the Backup set for restore backup set for more detailed information.
- Database Files - you can rename a database by changing the name or move the location by editing the data file locations of the restored files. Go to specify database files 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.
- Recovery State - choose the recovery state each database should be left in after the restore. Go to select the recovery state for more detailed information.
- Notifications - email a status notification to the appropriate database administrators about the restore operation. Go to configure notifications for more detailed information.
- Summary - before performing your Restore, you can go Back to 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.
...
- or Generate a Script. Go to review details for more detailed information.