Page History
...
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
...
you 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 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 SQL Safe 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 SQL Safe 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.
...