Restoring a SQL Database to a Disk

You can restore SQL Server data directly to a disk from the Command Center without the use of SQL.

Before You Begin

Verify that the SQL Server Agent is installed on the destination server.

Procedure

1. Access the databases that you want to restore using one of the following methods:

   1. To restore a single database to a point-in-time, complete the following steps:

      1. From the navigation pane, go to Protect > Databases, and then click the Databases tab.

         The Databases page appears.

      2. Select the database that you want to restore.

         The database page appears.

      3. Under Recovery points, select a date that contains a backup.

         Dates that are highlighted indicate that a backup exists for that day.

         Tip

         You can also select a specific time of the backup for a point-in-time restore.

      4. Click the date, and then click Restore.

   2. To restore one or more databases in an instance, complete the following steps:

      1. From the navigation pane, go to Protect > Databases.

         The Instances page appears.

      2. In the row for the instance, click the action button , and then click Restore.

         The Select database to restore page appears.

      3. Select the databases that you want to restore, and then click Restore.

   The Restore options dialog appears.

2. On the Restore to disk, do the following:

   1. From the Destination server list, select the server where you want the Commvault software to restore the database to.

   2. In the Path box, enter the full path to the directory where you want the Commvault software to restore the database to.

      Tip

      You can click the browse button to select the path.

3. Click Submit.