How to Restore Databases from Offline or File Copy Backups

 

Before you begin restoring data, make sure that your system is configured appropriately. To review, make sure that:

  • A recovery storage group exists. Because you are not using an online backup, the name of the recovery storage group does not matter.

  • The database that you want to restore has been added to the recovery storage group. The file names of the recovery storage group database match the file names of the original database. By default, the recovery storage group database is not mounted. Leave it in this state.

    Note

    After changing permissions, adding or deleting recovery storage group databases, or changing recovery storage group attributes, it may take up to 15 minutes for previously cached values to be refreshed. Until the cache has been refreshed, restoring to or extracting data from the recovery storage group may fail.

Procedure

To restore databases from offline or file copy backups

  1. Verify that all database files to be restored are in Clean Shutdown state. For detailed information, see How to Verify that all Database Files to Be Restored Are in Clean Shutdown State.

  2. Restore file copies of databases to a recovery storage group. For detailed information, see How to Restore File Copies of Databases to a Recovery Storage Group.

    Overview of how to restore data from an offline or file copy backup to a recovery storage group

    b4335407-fe10-4b39-a4cf-142c430d4517