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.
| 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 appreciatedSue |
|
|
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. |
 |
|
|
|
|
|
DBCC CHECKDB RUNNING TWICE!