Restore by Session in Microsoft SQL Server 2000, 2005 or 2008 Environments
80 Agent for Microsoft SQL Server Guide
Restore by Session in Microsoft SQL Server 2000, 2005 or 2008
Environments
You can restore databases by session in a single restore job using the Restore by
Session method.
To perform a restore using the Restore by Session method
1.
On the Restore Manager Source tab, select Restore by Session from the
drop-down list. A list of the media that you have used when backing up with
CA ARCserve Backup opens.
2.
To create a filter to restore only the sessions from a specific server or the
sessions from a specific database on a specific server, perform the following
steps:
a.
Click the Filter tab in the Restore Manager. The Filter dialog opens.
b.
Click the SQL Agent Filter tab. The SQL Agent Filter dialog opens.
c.
Enter a machine name to restore the sessions from a particular server, a
machine name and database name to restore the sessions of a particular
database, or a machine name, instance name, and database name to
restore a particular instance of a database and click OK.
Note:
Once you apply the filter settings, expand the media item to view the
results. If the media item was already expanded, collapse it and expand it
again to see the results.
If you do not want to create a filter, go to the next step.
3.
Choose the media containing the backup you want to restore, expand the
session containing that backup, and select the specific database or log you
want to restore.
4.
Right-click the name of the database or log you want to restore and select
Agent Options from the pop-up window.
The Agent Restore Options dialog opens.
5.
Perform one of the following to select restore options:
■
Click OK to accept the default options and allow the Automatic Selection
option select the appropriate restore sequence and options for the
restore job. The Automatic Selection option is the default option for
every restore job.
■
Manually select the options you want to use for this restore sequence
and click OK. For more information about options, see Restore Options.
Important!
The Automatic Selection option on the Agent Restore
Options dialog automatically selects the sessions which must be restored
and applies the selected options appropriately to each session.
6.
On the Source tab, ensure that the session you want to restore is selected.
