How to recover suspect database

Question

Post reply

How to recover suspect database

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Paul Randal One Orange Chip Points: 29544 More actions · Answer 1

Best practice to start a new thread for each problem.

What happened to the database?

Please post the output from:

select state_desc from master.sys.databases

where name ='yourdbname'

If this is a time-critical issue, you should call Product Support for assistance, as any help we're able to give you over the forums is going to involve time delays.

Thanks

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Guys,

If I don't want any 'data loss' and want to recover the database from Suspect mode, well, how to do it? Moreover, I don't have any 'backup' of the database also...

any suggestion friends?

Thanks.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Please post your question in a new thread. Thank you.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 4

SQL_Hunt

SSC-Dedicated

Points: 33518

July 22, 2010 at 10:29 pm

#1197322

Sure Gail..

Thanks.

vhr2003 SSC-Addicted Points: 455 More actions · Answer 5

Please go through this link, it may help you.

http://searchsystemschannel.techtarget.com/generic/0,295582,sid99_gci1247518,00.html

psen78 SSC Enthusiast Points: 140 More actions · Answer 6

Simple way to resolve the "msdb cannot be opened. it has been marked suspect by recovery" issue,

just run the INSTMSDB.SQL script, which is under SQL server install directory under INSTALL folder.

This script can be re-run WITHOUT causing loss of data, hence we only create the database if it missing (if the database already exists we test that it has enough free space and if not we expand both the device and the database)

Regards

Senthil Palanisamy

Singapore