Restore by Tree in Microsoft SQL Server 2000, 2005 or 2008 Cluster Environments
Chapter 5: Backing Up and Restoring in Cluster Environments 77
5.
(Optional) Use the Submit Job dialog to select the job execution time, submit
the job on hold, add an optional job name for the backup job, or select
source priority.
6.
Click OK to submit this job. If you selected Run Now, the Job Status window
opens. Use this window to monitor your job. For more information about the
Job Status window, see the
Administration Guide
.
Restore by Tree in Microsoft SQL Server 2000, 2005 or 2008
Cluster Environments
You can submit each backup session as a separate restore job if you use the
Restore by Tree method.
To restore using the Restore by Tree method in a Microsoft SQL Server
2000, 2005 or 2008 cluster environment
1.
On the Restore Manager Source tab, select Restore by Tree from the
drop-down list.
2.
In the navigation tree, expand the Microsoft SQL Server virtual server name
from which the database you want to restore was backed up. Click the yellow
database icon to expand the database instance and click the database you
want to restore to select it.
3.
To use the most recent backup, go to the next step.
To use a backup other than the most recent backup, click Version History.
The Version History dialog opens.
4.
Select a backup session to use for the restore and click Select.
Note:
Version History provides information on the media name attached to
each backup session, its backup session number, backup method, and the
date and time the backup was made. You can select the session to restore
from the backup media using Version History.
5.
Right-click the database name you selected and select Agent Options from
the pop-up window.
The Agent Restore Options dialog opens. The dialog varies depending upon
the restore sessions selected.
