MSSQL basic Tutorial: create a backup device

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"