Previous Topic: Restore Databases Using Restore by Session MethodNext Topic: Restore to Alternate Disk Locations Using Automatic Selection

Restoring Microsoft SQL Server Databases › SQL Agent Filter Options

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 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 later, 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.