MSSQL basic Tutorial: create a backup device

Source: Internet
Author: User
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"

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.