Solved

backup conflicting with integrity check

Posted on 2013-11-09
4
40 Views
Last Modified: 2016-07-10
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.
0
Comment
Question by:sqlserverdba
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 39636457
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
 
LVL 20

Expert Comment

by:Marten Rune
ID: 41701821
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question