Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When you select to perform an 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 The Restore Wizard opens  opens with the following options:

  • Target - in this section, you can select the SQL Server instance where you want to restore. Go

...

...

  •  for more detailed information. 
  • Databases - specify the databases you want to restore and the general location of the corresponding archive files. Go

...

...

  •  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

...

...

  • 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. 
Info

SQL Safe 8.4 Backup 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 setsoptions with compressed native backup files.

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

...