Data Engineering – Learn from the experts
-
How Database Snapshot Works
Its essential that a DBA understands what happens when a snapshot is created. The following process happens, Database snapshots operate at the data-page level. Before a page of the source database is modified for the first time, the original page is copied from the source database to the snapshot. This process is called a copy-on-write…
-
Uses of Database Snapshot
The following are the important usage of snapshots namely,
-
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,
-
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,.
-
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,
Got any recommendations?