SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 MsSql Server Database recovery
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

halgo
Starting Member

3 Posts

Posted - 10/29/2006 :  19:24:46  Show Profile  Reply with Quote
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.


My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,


I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.

if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.

Pleace help me.

Thanks.

paulrandal
Yak with Vast SQL Skills

USA
899 Posts

Posted - 10/29/2006 :  22:04:42  Show Profile  Visit paulrandal's Homepage  Reply with Quote
My guess is that the file you're trying to attach has a damaged or missing boot page and/or file header. The only way to attach the database is to create a database of equal size and name, then shutdown SQL Server and swap in the damaged files. The database may or may not come up, and if it does it will most likely be in suspect mode - from there you can at least get some of the data out.

Have you tried restoring from the customer's backups? I'm assuming they don't have any.

I have no idea what that 3rd party tool does so I can't comment on it.

Good luck.

Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

halgo
Starting Member

3 Posts

Posted - 10/30/2006 :  00:57:06  Show Profile  Reply with Quote
I dont have backup file...
I must recovery this database
thanks...
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

USA
899 Posts

Posted - 10/30/2006 :  01:05:14  Show Profile  Visit paulrandal's Homepage  Reply with Quote
So you need to try the method I suggested - if that doesn't work then there's nothing else you can do.

Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 10/30/2006 :  01:33:33  Show Profile  Reply with Quote
no backups?

we get this EXACT same question every month. How hard is it to setup an automated backup with the maintplan wizard?




-ec
Go to Top of Page

halgo
Starting Member

3 Posts

Posted - 10/30/2006 :  05:15:51  Show Profile  Reply with Quote
yes No backups.

I must recovery my .mdf file.
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 10/30/2006 :  11:57:05  Show Profile  Reply with Quote
quote:
Originally posted by halgo

yes No backups.

I must recovery my .mdf file.





Most likely there is no possibility for recovery. Read Paul Randal's message and follow his advice. He is the expert.



-ec
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000