SQLsafe allows you to restore multiple databases or files to any SQL Server instance you have registered. Ensure each registered instance is running the SQLsafe Backup Agent. Depending on your needs, you can restore databases from specific backup sets, or use the intuitive user interface to select specific points in time for each database you want to restore. When you select a time, SQLsafe automatically selects the appropriate backup sets that contain the data to be restored.
The Restore wizard will walk you through the restore process. Use the following checklist to ensure you have everything in place to restore your databases to the correct locations and to the correct points in time.
|Follow these steps ...|
Determine the location of the databases you want to restore to the SQL Server instance in question.
Determine which SQL Server instance should host the recovered databases.
For each database you need to recover, decide whether you will be restoring data from a specific backup set, or if you will restore data to a specific point in time. You can select the specifics in the Restore wizard.
Determine whether you want and are able to use InstantRestore.
To restore a database on a routine schedule, use a restore policy to maintain an up-to-date copy of your database.
The SQLsafe Restore wizard allows you to simultaneously restore multiple databases on different SQL Server instances, restore multiple databases on the same SQL Server instance, or restore individual databases. SQLsafe also allows you to verify the integrity of a backed up database without restoring it.
What is InstantRestore?
InstantRestore allows you to quickly come back on line while restoring your database. It is important to understand InstantRestore fully before undertaking this type of database restore. Make sure you know the supported restore information before attempting to use the InstantRestore feature. Note that InstantRestore supports only complete database restores and does not support file or filegroup restores.
How do I restore a backup using the Restore wizard?
- In the navigation pane, click Servers.
- In the Servers tree, select the SQL Server instance or specific database you want to restore.
- Select the appropriate restore operation (Database (s) or Database (s) Files) from the right-click context menu, the Restore option on the Management Console menu bar, or go to the File menu and look for the Restore option.
- On the Target tab, choose the instance to which you want to restore the database. You can disconnect any users before you restore the database. For more information, see Select the instance to restore. On this section, you can also choose to verify the integrity of a backup up database instead of restoring it. On the Advanced Options, you can select the number of threads for decompressing data. After making you choices, click Next.
- On the Databases tab, select the database or backup file you want to use for the restore. If you want to restore a backup that has moved or has no history, you can still select it using one of the file system tabs (Repository, File System, Target Server, TSM). For more information,see Select the database you want to restore. Click Next.
- On the Backup Sets tab, for each database you have chosen to restore, select either the time to restore to or the backup set to restore from. On this section you can also configure options for encryption settings, editing file paths, and enabling network resiliency options. For more information, see Select a backup set for the restore. Click Next.
- On the Database Files tab, configure the appropriate settings for each database you are restoring. On this section you can verify the database name and data file locations. For more information, see Enter the database files for the restore. Click Next.
- On the Recovery State tab, select the appropriate recovery state for each individual database (Fully accessible, Not accessible, Accessible but read-only). For more information, see Choose the recovery state for the restore. Click Next.
- On the Restore Type tab, select the appropriate restore type. You can select from normal SQLsafe restore or InstantRestore. For more information, see Choose the type for the restore.
- On the Notifications tab, select for which events to receive notifications about and specify the email addresses of those who will receive these notifications. In order for SQLsafe to send email notifications, you must configure your mail sever settings first. For more information go to Configure e-mail settings.
- On the Summary tab, review your selections. For more information, see Review the details of the restore. Click Restore.