You must create a backup device before performing a backup. A backup device is a storage medium used to store databases, transaction logs, files, and file group backups. The backup device can be a hard disk, tape, or pipe. SQLServer only supports backing up a database to a local tape drive, rather than a remote tape drive on the network. When using a disk, SQLServ
You must create a backup device before performing a backup. A backup device is a storage medium used to store databases, transaction logs, files, and file group backups. The backup device can be a hard disk, tape, or pipe. SQL Server only supports backing up a database to a local tape drive, rather than a remote tape drive on the network. When using a disk, SQL Serv
In progressBackupRequired beforeCreateBackupDevice.BackupDeviceIs used to store databases, transaction logs, files, and file groups.BackupStorage medium.BackupDeviceIt can be a hard disk, tape, or pipe. SQL Server only supportsBackupTo a local tape drive, rather than a remote tape drive on the network. When a disk is used, SQL Server allows the hard disk of the local host and the hard disk on the remote hostBackupDevice,BackupDeviceIt is stored as a file on the hard disk.
15.2.1 use SQL Server Enterprise Manager for managementBackupDevice
1. Use SQL Server Enterprise ManagerCreateBackupDevice
(1) use SQL Server Enterprise Manager,CreateBackupDeviceThe steps are as follows:
(2) Open the Management folder and select the Backup icon.
(3) Right-click Backup and select the New Backup Device option from the menu. The BackupDevice Properties-New Device dialog box is displayed. 15-1.
(4) In the Name column, enterDeviceName this name isBackupDevice.
(5) SelectBackupDeviceType. If File name is selected, hard disk is used.Backup, OnlyCreateOfDeviceThis option takes effect only when it is a hard disk file. If Tape Drive name is selected, the Tape is used.Device. OnlyCreateOfBackupDeviceIs a tape connected to the local serverDeviceThis option takes effect.
(6) Click OK.CreateBackupDevice.
2 use SQL Server Enterprise Manager to deleteBackupDeviceInCreateBackupDeviceStep 2, select the Backup icon, right-clickBackupDevice, Select the Delete option in the pop-up menu to DeleteBackupDevice.
15.2.2 Use System Process ManagementBackupDevice
1 sp_addumpdevice
In SQL Server, use sp_addumpdeviceCreateBackupDevice. The syntax format is:
View a full set of ms SQL statementsBasicTutorial"