Attach a corrupt database

Question

Attach a corrupt database

anacunhasena

Valued Member

Points: 67
More actions
August 29, 2008 at 4:31 pm

#189904

I have mdf and ldf, but i haven´t a backup.
The error is :The header for file 'database.mdff' is not a valid database file header. The PageAudit property is incorrect.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Paul Randal One Orange Chip Points: 29544 More actions · Answer 1

Game over I'm afraid - there's no way around that.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 2

What version of SQL did that database come from? What version are you trying to attach it to?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 738693 More actions · Answer 3

As Paul mentioned, if the headers are corrupted, there is no way to attach it. They saying goes:

Good resume

Good backup

You only need one.

Paul Randal One Orange Chip Points: 29544 More actions · Answer 4

And I should have mentioned, even if you can hack the database into the server with a similar process to the one I blogged yesterday, the database is still completely unusable because the file header is damaged.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

tosscrosby SSCoach Points: 18044 More actions · Answer 5

Steve Jones - Editor (8/30/2008)
As Paul mentioned, if the headers are corrupted, there is no way to attach it. They saying goes:
Good resume
Good backup
You only need one.

Granted, initially only one may be needed but, ultimately, you'll most likely be judged by your last good backups in the event of DR...Resumes may get you the job but backups will allow you to keep it. There are plenty of postings on most web boards stating "There's something wrong and I don't have a backup". How many companies will tolerate that? And, for how long? My experience - Few, if any, companies and not very long.....

-- You can't be late until you show up.