Incorrect PageAudit Property

Hello, after a fatal server crash (with no backups!!) I have tried to re-attach a database but I get the following message;

"Msg 5172, Level 16, State 15, Line 1

The header for file 'E:\Database.mdf' is not a valid database file header. The PageAudit property is incorrect."

The database files ( both mdf & ldf ) where recovered from a file system copy which was made while SQL Server 2005 was still running. The files where copied with Symantec Backup Exec (10d).

Is there any way that the database can be recovered from these files?

(I have tried a few 3rd party tools ie, Apex SQL Log & Recovery for SQL Server, but none of these where successful )

Would Miscorsoft Product Support be able to recover any data or does anyone know of any 3rd party companies that could help?

Any help would be greatly appreciated.

Roy

It could help... or maybe couldn't...

http://support.microsoft.com/default.aspx?scid=kb;en-us;268481

|||

The file header page is corrupt, which means the file cannot be attached. Product Support will not attempt data recovery for you - I advise you to contact a 3rd party to try it (and get a SQL backup strategy so this doesn't happen again).

Thanks

|||

Not all backup products are able to save the contents of a file while that file is open. Others do only if you enable (purchase) an extra option. If that were the case here (I can't speak directly to Backup Exec), what you have backed up is an empty file. This should be easy to see if you just open it in a hex editor.

I wish I had better news, but it doesn't look good.

|||

Roy,

If you email me directly at kfarlee@.microsoft.com , I'll put you in touch with a Backup Exec engineer who may be able to help figure out what happened.

sql