Tag: database snapshot

The following are the important usage of snapshots namely,

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.

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.

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,