Find out what makes DBCC CHECKDB makes database offline

Asked Jun 12 '18 at 15:54

Active Jun 12 '18 at 15:54

Viewed 365 times

We are using DBCC CHECKDB on our database since long. But from past 4-5 days, it makes our database offline.

Our database size is 80GB . The drive where tempdb is located, have free space of 50GB.

We had it online and it recently stopped working that way when database checks happens.

Anybody guide me how we can find out what is the real cause of offline dbcc check.

asked Jun 12 '18 at 15:54

Manish Pansiniya

What do your error logs say, what does the ouput of DBCC say, and what parameters/options are you passing to the DBCC CHECKDB? – dfundako Jun 12 '18 at 15:59
1

What stopped working? Are you saying that your database literally goes into an offline state when you run `DBCC CHECKDB`? – S3S Jun 12 '18 at 16:33
Log says success and it took around 17 min to do the check db. Do we have detailed log and if yes, where to find it/enable it. – Manish Pansiniya Jun 13 '18 at 07:08
@scsimon it do not stop working actually. It works but now with offline mode without any error. Just need to find out why before it was working online and now suddenly from past 3 days it does checkdb offline. – Manish Pansiniya Jun 13 '18 at 07:08
Did you figure out what makes the db go offline? – Sonali Gupta Sep 15 '22 at 17:58
Nope, we restored from backup. – Manish Pansiniya Dec 20 '22 at 10:39

0 Answers0