1、创建全面备份的设备
USE master
GOEXEC sp_addumpdevice 'disk','mybackdev',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\mybackdev.dat'
GO2、BACKUP DATABASE Device_Manage TO mybackdev WITH INIT
GO3、RESTORE DATABASE Device_Manage FROM mybackdev WITH REPLACE
USE master
GOEXEC sp_addumpdevice 'disk','mybackdev',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\mybackdev.dat'
GO2、BACKUP DATABASE Device_Manage TO mybackdev WITH INIT
GO3、RESTORE DATABASE Device_Manage FROM mybackdev WITH REPLACE
第二步
提示错误:无法打开备份设备 'mybackdev'。设备出现错误或设备脱机。详细信息请参阅 SQL Server 错误日志。
为什么?