#12002/4/23 21:54:34
操作如下：
1。建立一个备份设备，语句如下：
EXEC sp_addumpdevice 'DISK','storage_backup','c:\program files\mssql7\backup\storage_backup.bak'
2。判断备份设备是否存在，如果存在，则删除该备份设备，语句如下：
use master
if exists(select name from sysdevices
where name='storage_backup')
delete sysdevices where name='storage_backup'
执行操作时，出现在错误，错误提示如下：
Server: Msg 259, Level 16, State 2, Line 1
Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.
