Lesson 5: Recovering Data from Database Snapshots
Database Snapshots enable you to generate and use a read-only, stable views of a Database.You can use a database snapshot to recover lost data due to accidental change to a user database.
This lesson describes database snapshots and discusses how you can use them as a tool for assisting in disaster recovery.
In our practice exercise we will create a database snapshot by using Transact-SQL, then DROP a table of the source database and restore the table from the database snapshot.