Select Backup Destination

 

Applies To: SQL Server 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 logical 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 nameChoose this option to enter a local or remote file as the backup destination in the text box to:

Specify a local file, click the browse button to the right of the text box and navigate to a file on the fixed drives of the computer running the server, or enter the full path and file name directly; for example, C:\Program Files\Microsoft SQL Server\MSSQL\Backup\AdventureWorksBackup.bak.

Specify a remote file as your backup destination, enter its fully qualified universal naming convention (UNC) name. For more information, see Backup Devices (SQL Server).

 

 ** Important ** Backing up data over a network can be subject to network errors; therefore, we recommend that you verify the backup operation after it finishes. For more information, see RESTORE VERIFYONLY (Transact-SQL).
Backup deviceChoose this option to select a logical backup device.

Note: For information about how to create a disk backup device, see Define a Logical Backup Device for a Disk File (SQL Server).

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 driveChoose this option to select a tape drive as the backup destination from the list of tape drives that are physically connected to the computer that is running the server instance.

Note: Tape backup devices on remote computers are not valid backup destinations.
Backup deviceChoose this option to select an existing logical backup device. These logical backup devices correspond to tape drives that are physically connected to the computer that is running the server instance.

Note: For information about how to create a tape backup device, see Define a Logical Backup Device for a Tape Drive (SQL Server).

Backup Devices (SQL Server)
Media Sets, Media Families, and Backup Sets (SQL Server)

Community Additions

ADD
Show: