Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What can happen if CHECKDB maintenance job is killed in the middle ? Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2014 4:50 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:36 AM
Points: 774, Visits: 1,742
Hi,

I would like to know , just in case CHECKDB maintenance job is running for 5 hours and admin chosen to kill that operation.

Usually the job takes not more than 2 hrs.

What can happen if CHECKDB is killed in the middle of process?

What are steps to be taken care even before thinking of killing CHECKDB operation ?

Did anyone faced this situation any time? if so, please do share on how to handle such situation.

Thanks in advance.
Post #1573071
Posted Wednesday, May 21, 2014 4:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:37 AM
Points: 40,596, Visits: 37,053
Oracle_91 (5/21/2014)
What can happen if CHECKDB is killed in the middle of process?


The CheckDB operation stops.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1573072
Posted Wednesday, May 21, 2014 5:29 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:36 AM
Points: 774, Visits: 1,742
Is there anything happens internally because even the KILL takes a long time.
Post #1573082
Posted Wednesday, May 21, 2014 5:34 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:37 AM
Points: 40,596, Visits: 37,053
No.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1573085
Posted Wednesday, May 21, 2014 5:39 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:36 AM
Points: 774, Visits: 1,742
Thank you Gail. Again, in the fist place , is it perfectly safe to KILL checkdb operation if required?
Post #1573087
Posted Wednesday, May 21, 2014 6:11 AM This worked for the OP Answer marked as solution


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:37 AM
Points: 40,596, Visits: 37,053
It's perfectly safe to kill anything (well, unless your developers have written procedures which don't use transactions, but that's not a SQL internals problem)


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1573103
Posted Wednesday, May 21, 2014 6:15 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:36 AM
Points: 774, Visits: 1,742
Thank you
Post #1573106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse