Taking a Snapshot of Your Database
In SQL Server 2005, you have the ability to create a snapshot of your data. A database snapshot is essentially a placeholder of the time that it is taken. At any point going forward, you can revert to the snapshot and remove the changes that you have made to your data. Here is a short list of times you may find snapshots very helpful:
During the development cycle of the database or its related application, you can take a snapshot to create a baseline set of data to work with. Of course, this also helps developers as they will not have to recover databases as often and they can store multiple snapshots with different changes so they can go back as far as they need to without totally scrapping their work up to ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step 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.
