This sample illustrates using SQL Distributed Management Objects (SQL-DMO) objects supplied with Microsoft® SQL Server™ 2000. This Microsoft® Visual Basic® sample demonstrates how to use the BackupDevice Object to add and remove a backup device.
This is not intended to be a complete production application. It does not test to ensure that non-file based device types are valid on your system.
C:\Program Files\
Microsoft SQL Server\80\Tools\Devtools\Samples\Sqldmo\Vb\BackupDevice