Select Backup Destination

Use the Select Backup Destination dialog box to select a device as your backup destination. A backup destination can be either a disk or a backup device.

To use SQL Server Management Studio to back up a database


The options of this dialog box depend on whether you are selecting a destination on disk or on tape.

  • Destination on disk
    To specify a backup destination, choose one of the following options.

    File name

  • Destination on tape
    Specify a backup destination on a tape drive physically connected to the computer running the server (that is, the instance of the Database Engine). Choose one of the following options.

    Tape drive

See Also

Other Resources

Backup Devices
Media Sets, Media Families, and Backup Sets

Help and Information

Getting SQL Server 2005 Assistance