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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-24 : 08:18:26
|
| Bill writes "Our SQL server crashed hard and now we can not get the mdf to attached without a bunch of errors in most of the tables. Any suggestions on a third party tool to fix the problem would be helpful. I had an engineer from Microsoft try to recover the database with no luck. So far I have found these third party tools Red Gate SQL Log Rescue, Lumigent Log Explorer for SQL Server, ApexSQL, and MSSQLRecovery. Oh yes, the backups or lack of backups are bad too. Anyone have any ideas?" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-01-24 : 08:42:31
|
| Can you post the output from DBCC CHECKDB (yourdb) WITH ALL_ERRORMSGS, NO_INFOMSGS?What version are you using?Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
 |
|
|
|
|
|
Database crashed mdf is corrupt and problems with the ldf