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

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, and then expand a server.
   
   
2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database.
   
   
3. Click From device, and then click Select devices.
   
   
4. Under Restore from, click Tape or Disk, and then select a device from which to restore.

   If no backup destinations appear, click Add to add an existing backup device or to create a new one. The backup device must reference the backup device files created at the primary server.

5. In the Restore Database dialog box, click View contents.

See Also

Verifying Backups

Viewing Information about Backups