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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-19 : 08:08:54
|
| Jacob Ohlson writes "Hello all,I'm stuck in a bit of a situation (due to customers lack of ability to manage backups). Anyway, I have a database backup that I must restore back into a SQL 2000 server. (it was from an SQL 2000 server that has crashed).I have 10 of the .BAK files - I've tried to restore all of them, same error message.I get the error "Microsoft SQL-DMO (ODBC SQLState:42000) - Error 3242: The file on the device 'd:\restore\intactt_db_200609102130.bak' is not a valid Microsoft Tape Format backup set. RESTORE HEADERONLY is terminating abnormally.'I have looked / checked / reviewed everything I can. It just seems strange all 10 of these files are not restorable!??!I've tried both a Windows 2003 Server with SQL 2000 (SP4) and a Windows 2000 Server with SQL 2000 (SP4)... Surely it doesn't need an earlier SP of SQL?From what I can see - it appears these files may be corrupt?!? Is there a way of fixing them?This is desperate - the customer is prepared to pay to get these fixed professionally if that is the answer. Any suggestions??THANKS IN ADVANCE!" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-19 : 08:41:38
|
| Have you seen this article:[url]http://support.microsoft.com/kb/905616[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-19 : 21:46:20
|
| if u need to do this without wasting much time,use any of the third-party backup solution, they can fix this prob ASAPits me monty |
|
|
|
|
|
|
Restoring database issues