通过

BackupDevice Object

后续版本的 Microsoft SQL Server 将删除该功能。 请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

The BackupDevice object represents the properties of a Microsoft SQL Server backup device.

显示当前对象的 SQL-DMO 对象模型

注释

SQL Server backup devices specify the behavior of specific backup media, usually tape. Backup devices are not required when issuing a BACKUP or RESTORE statement and are not required by the Backup object.

With the BackupDevice object, you can:

  • Define a new backup device for a server running SQL Server.

  • Change the definition of an existing SQL Server backup device.

The Name property of the BackupDevice object must match the definition of the sysname SQL Server data type.

To create a backup device

  1. Create a BackupDevice object.

  2. Set the Name property.

  3. Set properties that define the behavior or use of the device, such as the tape label skip parameter or the physical ___location.

  4. Add the BackupDevice object to the BackupDevices collection of a connected SQLServer object.