Home Forums SQL Server 2008 SQL Server 2008 Administration Database Snapshot RE: Database Snapshot
Ant-Green
SSC Guru
Points: 113445
More actions
February 15, 2013 at 2:09 am
#1588233
I do both, ensure I have a backup and log chain, and do a snapshot, its much quicker to restore from snapshot than backup.
Restoring from snapshot reverts everything you have done, DML & DDL.
If you get corruption, then you just restore from backup.