backup conflicting with integrity check

Hi, I have a long running backup of a 300 GB database, It seems to be conflicting with integrity check and both are taking a long time. Can I go ahead and kill the integrity check. I just haven't had to do that before and wondering if integrity check will have a rollback. Or is it safe to kill it in production and run the integrity check later. Please let me know. Thank you.
LVL 1
sqlserverdbaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
There is no rollback for integritycheck. Though it will not start where it left off, but rather begin from the beginning again.

Suggest you look att how long these operations take, and Schedule accordingly.

But... If checkdb suddely takes longer time to run, this could be because it's fount some corruption and needs to do a Deep dive. Then if you kill the process, it's not doing anything good for you at all.

If need be, take the current backup, and restore on a separate system. Now let dbcc checkdb run its cycle on this database. Checkdb is your safeguard against a failing subsystem. You would not want to kill a process that can deliver this information to you.

it may be that the backup takes time due to I/O problems, and integrity check also looks at the same faulty subsystem.

Time to read up, some good links and the last one  on errors in the windows application/system logs should be checked Before you kill any process at all, in my opinion.
http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-how-long-will-checkdb-take-to-run/
http://www.sqlskills.com/blogs/paul/do-transactions-rollback-when-dbcc-checkdb-runs/
http://www.sqlskills.com/blogs/paul/dont-confuse-error-823-and-error-832/


Regards Marten
0
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
My solution is complete. First paragraph tells the asker he can kill the process since there is no rollback to wait for.
In addition to this I'm giving sound advice not to just ignore it, but to investigate weather dbcc checkdb found somerhing or not. Plus valid links for further reading.
I belive the community benefits if this post is left as a searchable solution.
Regards Marten
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.