• Grant Fritchey (8/20/2013)


    But, by snapshotting to a seperate set of disks and then performing DBCC there, you won't be seeing the physical layout checks run against the original set of disks.

    Doesn't that only apply to the changed data pages? The original version of all these changed data pages are stored in the snapshot file(s). All non-changed data pages are read from the database location.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **