SQL-Articles
On Premise and Cloud Database Knowledge Base

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.

Database Snapshots are completely unrelated to Snapshot Replication and Snapshot Isolation.

Links Related to Snapshot:

Uses of Database Snapshot

How Database Snapshot works

Creating Database Snapshot

Restoring from Database Snapshot

Deleting Database Snapshot

Pros & Cons of Database snapshot

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*