GilaMonster (8/20/2013)
Grant Fritchey (8/20/2013)
I thought the internal/hidden snapshot was a different critter than the snapshots we create. But, hey, happy to be wrong.No, the same thing, same behaviour, same mechanics.
The only difference with the CheckDB snapshot is that it's created on all editions (only on Enterprise can you create an explicit snapshot) and it puts the snapshot files into NTFS alternate streams.
Thanks for understanding to get the Checkdb implementations with the snapshots. But here one more thing , will it DBCC Checkdb work on standard edition as i am not able to run DBCC Checkdb against database and the drive also having sufficient free space for datafile. Will it DBCC Checkdb creates snapshot in standard edition ? and Will it be possible to create snapshot by manually in standard edition?.... Please advise !