Reverting to a Database Snapshot for Recovery
If you have a database snapshot defined for a source database, you can use that snapshot to revert the source database to that snapshot’s point-in-time milestone. In other words, you consciously overlay a source database with the point-in-time representation of that database (which was generated when you created the snapshot). You must remember that you will lose all data changes that occurred from that point-in-time moment and the current state of the source database. However, this may be exactly what you intend.
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
