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 |
|
halgo
Starting Member
3 Posts |
 Posted - 2006-10-29 : 19:24:46
|
| 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
899 Posts |
Posted - 2006-10-29 : 22:04:42
|
| 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 RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
halgo
Starting Member
3 Posts |
Posted - 2006-10-30 : 00:57:06
|
| I dont have backup file...I must recovery this databasethanks... |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-10-30 : 01:05:14
|
| So you need to try the method I suggested - if that doesn't work then there's nothing else you can do.Paul RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-30 : 01:33:33
|
| no backups?we get this EXACT same question every month. How hard is it to setup an automated backup with the maintplan wizard? -ec |
|
|
|
halgo
Starting Member
3 Posts |
Posted - 2006-10-30 : 05:15:51
|
| yes No backups.I must recovery my .mdf file. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-30 : 11:57:05
|
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 |
|
|
|
|
|
|
|
|
MsSql Server Database recovery