Sample Header Ad - 728x90

VLDB - Create SQL DB Snapshot And Run Granular DBCC CHECKDB Commands

2 votes
1 answer
459 views
I have a 25TB db (SQL2008 Enterprise SP4) that appears to not have had CHECKDB run on it in production. No idea if it was run against a restored backup somewhere at sometime. Right now I don't have space to restore a copy on another server connected to the same storage. I need to be able to run checkcatalog, checkalloc and checktable but even for small tables it doesn't appear to be able to create the internal sparse file dbcc snapshot. So I was wondering if I can create a SQL database snapshot on another drive and then run those commands against that and then drop the snapshot db once complete. Thanks! --Todd
Asked by Todd Kleinhans (23 rep)
Mar 8, 2016, 11:13 PM
Last activity: Mar 8, 2016, 11:56 PM