How to Restore SQL Databases

This section provides information about restoring the Microsoft SQL databases.

Follow these steps:

1. Navigate to Protect > Sources.
2. From the list of available sources, click the Action drop-down list of a source that you want to recover, and then click Start Recovery.
3. The Restore wizard appears.
3. On the Restore wizard, select RPS.
4. The Restore wizard refreshes and displays the available recovery options.
4. Select Recover SQL Databases.
5. The Recover SQL Databases wizard appears.
5. From the Recovery Point Date section, select a date.
6. The corresponding recovery points for that date are displayed, with the name of the backup, size of the file or folder, and the date of the backup performed with time.
7. Note: If the recovery point you are attempting to restore is encrypted, the Encryption/Session Password dialog opens and prompts you to enter the encryption or session password.
6. Select the SQL datastore to restore, and then click Next.
7. Select the restore destination, and then click Next.
8. 
9. The available destination options are:
10. Restore to original location

Restores to the original location from where the backup image was captured.

Dump file only

For this option, Arcserve UDP Agent (Windows) dumps the selected Microsoft SQL database files to the specified folder. When you select this option, you can specify or browse to the folder location where the dump file needs to be restored.

Restore to alternative location

Restores to an alternate location (not the original location).

11. Note: For agentless machine, the Restore to original location and Restore to alternative location options are disabled.
12. The Recover SQL Databases - Job Level Options page appears.
8. On the Recover SQL Databases - Job Level Options page, do the following, and then click Next:
9. Recovery State
• RECOVERY Mode: By default, this option is enabled. It makes the SQL database online to allow data recovery and provides you permission to access the restored database. For an example of restoring to the original location using RECOVERY Mode, see RECOVERY Mode Example.
• NORECOVERY Mode: The database transitions to a ‘RESTORING’ state to prevent users from accessing the database. To restore the last backup and bring the database online for usage, use the RECOVERY Mode option. For an example of restoring to the original location using NORECOVERY Mode, see NORECOVERY Mode Example.
10. Database Consistency Check
11. To make sure that the database is consistent after a restore, select the Run database consistency check after the restore check box. This option checks the physical and logical integrity of objects in an SQL Server database. The Mark the restore as failed if the consistency check fails option indicates when the restore job fails if the database consistency check fails for the selected database.
12. Miscellaneous
• Force restore over existing files or database: This option overwrites the existing database files located at the restore destination. Not selecting this option for an existing database file can make the restore incomplete. You can skip this option when the database file is new.
• Restricted user access after restore: This option restricts access to the database file for a specific group of users such as sysadmin, dbcreator, and/or db_owner. These users have permissions to modify the database.
• Note: If the source database was already in the restricted mode during the backup, the restored database automatically stays in the same mode.
13. 
9. Do one of the following based on the restore destination selected:
For Original Location
1. On the Recover SQL Databases - Original Location page, to configure or change the configuration at a database level, click the Configure button.
2. 
3. The Additional Database Options dialog appears.
2. Verify and make any changes to the database options, as needed, and then click OK to return to the Recover SQL Databases - Original Location page.
3. 
3. Click Next.
4. The Recover SQL Databases -Summary page appears.
4. Review the displayed information to verify that all the restore options and settings are correct, and then do one of the following:
• If the summary information is incorrect, click Previous and go back to the applicable dialog to change the incorrect setting.
• If the summary information is correct, click Start Recovery to launch the restore process.
For Alternate Location
1. On the Recover SQL Databases - Alternate Location page, click the Destination Instance Name drop-down list to view the size and the FileStream enabled status of the selected database.
2. Note: If a database is FileStream Enabled, the Destination Instance Name field lists only FileStream Enabled servers. However, if the FileStream is not enabled, the Destination Instance Name displays both FileStream enabled and disabled databases.
2. To rename the database, type the New Database Name as needed.
3. To configure or change the configuration at a database level, click the Configure button.
4. 
5. The Additional Database Options dialog appears.
4. In the Recovery Options tab, verify and make any changes to the database options, as needed.
5. In the Database Settings tab, do the following:
1. To select the Destination Location, click the (…) button.
2. Note: When you change the destination location, it also updates the destination for all the database files.
2. Under File Name Settings (Optional), you can change the file names partially or fully. To replace the file name, type the new file name in the Replace With field.
3. Click Apply to make the changes.
4. Note: The new file names appear under the Destination File Name column.
6. 
6. Click OK to return to the Recover SQL Databases - Alternate Location page.
7. Click Next.
8. The Recover SQL Databases - Summary dialog appears.
8. Review the displayed information to verify that all the restore options and settings are correct, and then do one of the following:
• If the summary information is incorrect, click Previous and go back to the applicable dialog to change the incorrect setting.
• If the summary information is correct, click Start Recovery to launch the restore process.
10. Notes:
• After the restore finishes, view the restore status along with the rename of the database in the Logs page.
• The change in the database name reflects in the SQL Management Studio.

The restore of Microsoft SQL database is started successfully.