BackupDevices Collection (SQL-DMO)

The BackupDevices collection contains BackupDevice objects exposing the backup devices defined on a server running Microsoft® SQL Server™.

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")

    

Methods