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, click Solutions > Databases > SQL Server, and then click the Databases tab.

         The Databases page appears.

      2. Select the database that you want to restore.

         The database details page appears.

         Under Backup history, select a date that contains a backup.

         Dates with dots indicate that a backup exists for that day.

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

      3. Click the dots icon next to the time, and then select Restore.

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

      1. From the navigation pane, click Solutions > Databases > SQL Server.

         The Instances page appears.

      2. Right-click the instance that you want to restore, and then click Restore.

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

   The Restore options dialog appears.

2. Click Restore to disk.

3. From the Destination server list, select the server where the software will restore the database.

4. In the Path box, type the full path to the directory where the software will restore the database.

5. Click Submit.