Suspect Marked msdb - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Suspect Marked msdb

Author

Topic

micnie_2020
Posting Yak Master

232 Posts

Posted - 2012-05-07 : 05:59:34

Dear All,

http://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/

I had tried above all method, but failed.

I have a mdf file from a crashed machine and when I try to restore using different tricks I keep getting the error “The log cannot be rebuilt because the database was not cleanly shut down” . Please let me know if you have a solution to restore the DB.

Please advise.

Thank you.

Regards,
micheale

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-05-07 : 09:43:50

1) Do you have a backup form which you can restore?
2) Have you tried
putting it into EMERGENCY mode
DBCC CHECKDB (MY_DB, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
SINGLE-USER_MODE
DBCC CHECKDB (MY_DB, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
MULTI_USER_MODE

This is an absolute last resort , once you've exhausted all other possibilities. I've used on a Error: 3414, Severity: 21, State: 1.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

prett
Posting Yak Master

212 Posts

Posted - 2012-05-08 : 06:54:27

1) Restore from last backup is most recommended & safest solution.

2) If there is no backup. Check this link: http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

If above solutions did not work then try SQL Recovery Software to recover corrupt database. You can search about this software on Google:
http://lmgtfy.com/?q=sql+database+recovery+software

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources