Displaying Information About Dump Devices

SQL Enterprise Manager provides several ways to view information about dump devices. You can view a list of dump devices, view information about the backups stored on a device, or view the physical name (path and filename) of a device.

    To view a list of dump devices on a server

1. From the Server Manager window, select a server, and then open the Dump Devices folder.

   The dump devices for this server are listed.

   

2. To view information about the backups that have been stored on a dump device, choose the device's "" button.
   • Full database dumps are indicated by a database icon.

     

   • Transaction log dumps are indicated by a page icon.

     

Information about dump devices can also be viewed from the Database Backup/Restore dialog box while managing backup and restoration.

    To view dump device information while managing backup and restoration

1. From the Server Manager window, select a server, and then from the Tools menu choose Backup/Restore.

   The Database Backup/Restore window appears. The dump devices for this server are listed.

2. To view information about the backups that have been stored on a dump device, choose the device's "" button.
   • Full database dumps are indicated by a database icon.

     

   • Transaction log dumps are indicated by a page icon.

     

3. To view header information about the backups that have been stored on a dump device, select the device, and then choose the Info button.

   The Header Information dialog box appears.

   

   For a description of the information presented in this dialog box, see Chapter 12, Backing Up and Restoring.

    To view the physical name of a dump device

• From the Database Backup/Restore dialog box, select a dump device, and then choose the Edit button.

  The Database Backup/Restore dialog box appears.

  

  The Device Path box displays the physical name of the dump device.

The sp_helpdevice system procedure can also display information about dump devices. And you can query the sysdevices system table to view information about dump devices. For more information, see the Microsoft SQL Server Transact-SQL Reference.