Categories
DBA

Uses of Database Snapshot

The following are the important usage of snapshots namely,

Categories
DBA

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
DBA

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.

Categories
DBA

Pros and Cons of Database Snapshot

The following are the advantages and disadvantages of database snapshot.

Categories
DBA

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,