--1.添加 tapedump1 设备,其物理名称为 \\.\tape0。
exec sp_addumpdevice 'tape', 'tapedump1','\\.\tape0'
go--2.执行备份的sql语句
backup database pubs to tapedump1
go
我执行了以上两步骤,出现如下提示:Server: Msg 3230, Level 16, State 1, Line 3
Operation on device 'tapedump1' exceeded retry count.
Server: Msg 3230, Level 16, State 1, Line 3
Operation on device 'tapedump1' exceeded retry count.
Server: Msg 3013, Level 16, State 1, Line 3
Backup or restore operation terminating abnormally.
exec sp_addumpdevice 'tape', 'tapedump1','\\.\tape0'
go--2.执行备份的sql语句
backup database pubs to tapedump1
go
我执行了以上两步骤,出现如下提示:Server: Msg 3230, Level 16, State 1, Line 3
Operation on device 'tapedump1' exceeded retry count.
Server: Msg 3230, Level 16, State 1, Line 3
Operation on device 'tapedump1' exceeded retry count.
Server: Msg 3013, Level 16, State 1, Line 3
Backup or restore operation terminating abnormally.
不过我的磁带机有显示正常啊 前周还能正常工作 备份时磁带机前的两个灯“tape”与“clean”一直闪着 备份结束时 "clean"灯还在闪。