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,.
Categories
Tag: database snapshot
Categories
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,
Categories
Uses of Database Snapshot
The following are the important usage of snapshots namely,
Categories
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 operation. The snapshot stores the original page, preserving the data records as they existed when the snapshot was created.
Categories
Database Snapshot
What is a Database Snapshot?
* The Database Snapshot is a new feature that is available in Enterprise edition of SQL Server 2005.
* It provides a read-only, static view of a database.
* Multiple snapshots can exist for a single database on the same server instance as the database.