Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring database issues

Author  Topic 

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??


Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-19 : 08:41:38
Have you seen this article:

Harsh Athalye
Go to Top of Page

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 ASAP

its me monty
Go to Top of Page

- Advertisement -