Tag: database snapshot
Pros and Cons of Database Snapshot
The following are the advantages and disadvantages of database snapshot.
Creating Database Snapshot
One of the exasperating things while creating a snapshot is that you cannot use SQL Server Management Studio (SSMS) instead you need to make use of T-SQL. I am creating a snapshot of the database Deepak as follows,
How to Delete a Database Snapshot
You cannot drop a database before dropping the snapshot created for the database. Now I have dropped the snapshot Deepak_snapshot_2030 created for the db Deepak. Refer the figure below illustrating how to drop a database snapshot,.
Restoring from Database Snapshot
Assume you had dropped some records from your database but prior to dropping it you have taken a snapshot of you db, so the snapshots come handy in such scenarios. You can restore back the records from this snapshot as shown in the below figure,
Uses of Database Snapshot
The following are the important usage of snapshots namely,