The BackupDevice object represents the properties of a Microsoft® SQL Server™ backup device.
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:
The Name property of the BackupDevice object must match the definition of the sysname SQL Server data type.
To create a backup device
To change the definition of an existing backup device
ReadBackupHeader Method (BackupDevice) | Remove Method (Objects) |
ReadMediaHeader Method (BackupDevice) | Script Method (BackupDevice Object) |
DeviceNumber Property | Status Property (BackupDevice) |
Name Property | SystemObject Property |
PhysicalLocation Property | Type Property (BackupDevice) |
SkipTapeLabel Property |