SQL-DMO
BackupDevices Collection
The BackupDevices collection contains BackupDevice objects that expose the backup devices defined on a server running Microsoft® SQL Server™.
Methods
| Add Method | Remove Method (Collections) |
| Refresh Method |
Remarks
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 for its functioning.
With the BackupDevices collection, you can:
- Create a new backup device definition for a server running SQL Server.
- Remove a backup device definition.
For more information about creating backup devices, see BackupDevice Object.
To remove a backup device
- Use the Remove method of the BackupDevices collection of a connected SQLServer object. Indicate the targeted backup device using the backup device name or the ordinal location in the collection, as in:
oSQLServer.BackupDevices.Remove("Northwind_Tape")