?
Solved

backup conflicting with integrity check

Posted on 2013-11-09
4
Medium Priority
?
56 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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.
Viewers will learn how the fundamental information of how to create a table.

719 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