Restoring a SQL Server Database in the ServiceNow Commvault Application

You can restore Microsoft SQL Server databases in the ServiceNow Commvault application.

You can perform the following types of database restores:

• In-place restore, which restores the database to the server from which it was backed up.

• Out-of-place restore, which does one of the following:

  • Restores the database to the server from which it was backed up, but allows you to rename the database and select a new file location for it.

  • Restores the database to a different server.

Procedure

1. From the ServiceNow navigation pane, go to SQL Servers.

   The SQL Server Instances window appears.

2. On the Databases tab, in the Actions column, click the action button for the database that you want to restore, and then click Restore.

   The SQL DB Restore window appears.

3. To perform an in-place restore, on the Inplace restore tab, click the Submit button.

   Caution: During an in-place restore, the existing production database is overwritten by the version that you are restoring.

4. To perform an out-of-place restore, complete the following steps:

   1. Click the Out of place restore tab.

   2. In the Destination Server list, select the server where you want to restore the database.

   3. In the Destination Instance list, select the instance where you want to restore the database.

   4. Optional: In the Destination Database field, enter a new name for the restored database.

   5. Optional: From the Database File list, select a logical database file name.

   6. Optional: In the Database File field, enter a new database file name.

   7. Optional: In the Database File Path field, enter a new path where you want to restore the database.

   8. Select a recovery type (Recovery, No Recovery, or Stand by).

   9. Click the Submit button.