Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2007-12-17 : 03:38:58
|
| i have taken full database backup on tape drive one week ago,by automated scripts ,now when i check the maintenance plan history , it says the task failed and gives a message that unable to open the \\.\tape0 ,with error ([Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\.\tape0'. Device error or device off-line. See the SQL Server error log for more details.[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.) |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-12-17 : 10:59:52
|
| in the device manager or the sql manager, does the tape show up as an active device, something might have happened.e.g. you changed the port. the sql server is pretty unforgiving in the way that you might end up having to reboot the server.RegardsParesh MotiwalaBoston, USA |
 |
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-17 : 22:42:37
|
| i have two servers where i have to take a backup on tape. one of the two servers displays the tape drive in enterprise manager but the other one does not , i checked in device manager and it does not show any conflicts.(does not show ! or ? ) .. what else could be the issue |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 23:49:08
|
| Did you install tape driver on that server? Where is the tape device? |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-17 : 23:51:17
|
| ya i find the driver installed for the tape drive in the device manager which shows that the device is working properly.and the location is \\.\tape0 on the server |
|
|
|
|
|
|
unable to backup to tape drive