Use this command to remove all the files in addition to
the device definition:
Sp_dropdevice @logicalname='AWBackup', @devfile='DELFILE'
The literal 'DELFILE' is required for completely dropping the device and all the files
associated with it??”not the most intuitive command. A simple Y|N or 0|1 flag would make
more sense. Keep in mind that just dropping the device doesn??™t remove the files and
won??™t reclaim space. If you delete a backup device, you??™ll be asked whether you want to
delete the files.
Advantage of Backup Devices
Again, the main advantage to using a backup device is to provide a logical name for the
backup location. That way, if you change or add hardware and need to change the location
of the file or tape, you won??™t need to modify your backup command. Consider the
following command:
BACKUP DATABASE AdventureWorks
TO AWBackup
This command backs up a database to the device represented by AWBackup. The
actual, physical device could be a tape drive or a disk file, and it can hold multiple backups
and all backup types (including full, differential, and log).
Pages:
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95