SQL Agent Filter Options
Chapter 4: Restoring Microsoft SQL Server Databases 63
SQL Agent Filter Options
You can use the SQL Agent Filter option in the Restore Manager to display backup
sessions of a particular database belonging to a particular server name and, for
Microsoft SQL Server 2000 and Microsoft SQL Server 2005 or later, a particular
instance. This option is available when you are using the Restore by Session
method.
To display backup sessions of a database belonging to a server name
1.
Open the Restore Manager and select Filter from the Restore menu.
2.
In the Filter dialog, select the SQL Agent Filter tab.
3.
If you are using Microsoft SQL Server 7.0, enter a machine name, or a
machine name and database name.
If you are using Microsoft SQL Server 2000 or Microsoft SQL Server 2005,
enter a machine name and a database name, or a machine name, instance
name, and database name.
Note:
If you have several databases with the same matching character set
in the name, they are all displayed.
4.
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.
Restore to Alternate Disk Locations Using Automatic
Selection
You can restore a database to a different location on a disk (for example, to a
different drive letter or directory path, or with a different file name) while using
Automatic Selection only if the Agent Restore Options dialog displays file path
entries for the data files.
Note:
The Agent Restore Options dialog does not have the complete file list for
Transaction log and differential backups made using BrightStor ARCserve
Backup Version 9.0 or earlier, or BrightStor Enterprise Backup Release 10.0.
To determine whether you can use Automatic Selection to restore a
database or session to a different location
1.
Right-click the database, if you are using Restore by Tree, or the last backup
session for this database, if you are using Restore by Session.
A pop-up window opens.
