Lesson 5: Recovering SQL Server Data from Database Snapshots

Опубликовано: 03 Октябрь 2024
на канале: Efren Plaza
29
0

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.