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)
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.
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.