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
 General SQL Server Forums
 New to SQL Server Administration
 DBCC CHECKDB RUNNING TWICE!

Author  Topic 

suedunham2
Starting Member

2 Posts

Posted - 2014-11-22 : 18:05:17
I am in a bit of a fix and would like to have some advice from the SQL experts who frequent your SQLBlog.com site. I cannot see how to apply to post a blog but would appreciate an answer quickly! I was setting extra dbcc plus backup of a large Sharepoint database and accidentally set a dbcc checkdb (no repair option) to run at 7.15pm and at 8.15pm. They are now running at the same time and it has gone beyond the time when I would expect the first to finish (2h 30 mins). The processes are not apparently blocking each other, both show blocks of themselves (but I have seen this before) which come and go. I just don't know what to do - should I wait to see if they finish? Could I stop one of the jobs? Or should I kill one of the processes? I do not want to risk leaving the database in an unusable state. This is on SQL Server 2008.

Any help would be much appreciated
Sue

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-11-22 : 19:55:52
Kill one or both of them, CHECKDB is a non-destructive process, you can interrupt it any time as long as it's not doing a repair operation.
Go to Top of Page
   

- Advertisement -