January 13, 2015 at 11:45 am
Hello smart people,
I just want your opinion on this, I have very large Database and need to run DBCC CHECKDB on this. I found out running 'physical only' option takes less time. But my question is, Can I create database snapshot on the database on PROD server and run CHECHKDB on that? Is this a good/valid option? if it is , what's the benefit doing this instead of running on the actual DB? If I run on the 'Snapshot' wouldn't be there huge log generated and TEMPDB get hammered? Sorry, too many questions, please suggest me with a good option.
January 14, 2015 at 1:23 am
Since CheckDB generates a snapshot and runs against that shapshot by default, manually generating a snapshot's not going to achieve very much.
Physical_Only means a lot of checks are skipped. While it's OK to use that, you need to run a full checkDB often enough that should it pick up corruption you have options on how to fix the problem. That means at least once within your backup retention period
What exactly do you mean by 'very big database'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2015 at 7:41 am
Thanks for your reply. 1.75 TB database
January 14, 2015 at 7:46 am
Ok, that's pretty big.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply