Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

backup conflicting with integrity check

Posted on 2013-11-09
4
Medium Priority
?
61 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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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 ?
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

886 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