You can restore SQL Server data directly to a disk without using SQL.
Before You Begin
Verify that the SQL Server agent is installed on the destination server.
Procedure
-
From the Command Center navigation pane, go to Protect > Databases.
The databases Overview page appears.
-
On the Instances tab, click the name of the instance that has the databases that you want to restore.
The Overview page for the instance appears.
-
In the Recovery points section, select a date that contains a backup.
Dates that are highlighted indicate that a backup exists for that day. You can also select a specific time of the backup for a point-in-time restore.
-
Click RESTORE
The Backup content page appears.
-
Select the databases you want to restore, and then click RESTORE.
The Restore options dialog box appears.
-
Select Out of place.
-
From the Restore type list, select Restore to disk.
-
From the Destination client list, select the client to restore the database files to.
-
In the Destination folder box, enter the full path to the location where you want the database files restored.
-
You can configure a schedule to repeat this restore operation. To create a schedule, do the following:
-
Click Schedule.
The Add schedule dialog box appears.
-
In the Name box, type a name for the schedule.
-
Configure the Frequency and Repeat parameters.
-
To specify exceptions to the schedule, click Exceptions.
The Exceptions dialog box appears.
-
Configure the exception parameters:
-
You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.
-
Click Save when you have finished configuring the exception parameters.
-
-
Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.
-
To save the schedule and return to the restore dialog box, click Schedule.
-
-
Click SUBMIT.