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
- How to: Back Up a Database (SQL Server Management Studio)
- How to: Create a Differential Database Backup (SQL Server Management Studio)
- How to: Back Up Database Files and Filegroups (SQL Server Management Studio)
- How to: Back Up a Transaction Log (SQL Server Management Studio)
Options
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