Database is in suspect mode

Question

Post reply

Database is in suspect mode

Viewing 4 posts - 1 through 5 (of 5 total)

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

A full log will not send a database suspect. If your database is suspect, something else is the cause.

What does the SQL error log say?

What's the exact value for status_desc for this database (from sys.databases)?

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 learner22 Default port Points: 1487 More actions · Answer 2

you are right, full log was not the reason database became suspect but

lite speed was blocking while database was trying to recover some transactions

thanks

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

So is it fixed?

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 learner22 Default port Points: 1487 More actions · Answer 4

yes, its fixed by re-starting windows server and that stopped the litespeed that is causing the issue with the database

thank