• I use database snapshots for some of the reasons mentioned above, but I also use it to run DBCC CHECKDB on my mirror instance instead of running it on the principal.

    I know this thread has gone in a little bit of a different direction, but just in case someone searches for reasons why to use snapshots I wanted to add my $.02 🙂



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]