How to view the data and log files in a backup set (Enterprise Manager)

To view the data and log files in a backup set

1. Expand a server group; then expand a server.
2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database....
3. On the General tab, select From device.
4. Click Select devices....
5. Click Add... to specify each backup device containing the backup from which you need to restore.

   In the Choose Restore Destination dialog box, specify either the name of the file or the backup device containing the backup.

6. In the Restore Database dialog box, click View contents.... Select the backup set to view.

   ---

   Note This option scans the backup set for the backup content information and can be time consuming, especially when using tape devices. If you already know the backup set to restore, enter the backup set number in Backup number instead.

   ---

7. In the Restore Database dialog box, click the Options tab. The list of logical and physical file names comprising the backup set is listed.

See Also