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 |
|
Kotamraju
Starting Member
3 Posts |
 Posted - 2007-03-31 : 01:24:08
|
| I have used ntbackup tool to store the backup file to the tape.then when i am trying to use the tape to restore database directly from tapeuse masterrestore database testfrom tape='\\.\tape0'Server: Msg 3143, Level 16, State 1, Line 2The data set on device '\\.\Tape0' is not a SQL Server backup set.Server: Msg 3013, Level 16, State 1, Line 2RESTORE DATABASE is terminating abnormally. |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-31 : 01:50:09
|
| Try restoring tape to disk and then restore db from disk...if it fails then it could be corrupt tape...MohammedU |
 |
|
|
Kotamraju
Starting Member
3 Posts |
Posted - 2007-04-03 : 02:38:10
|
| I have tried restoring the file from tape to disk .The restoration is working fine from disk for the same file.But I want to restore it from tape only.This shows that the tape is not corrupt. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-03 : 02:44:47
|
| NTBackup and SQL Server BACKUP command are not compatible.You should use NTBackup to restore from tape and then attach database.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Problem in restoration from tape drive