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

By Deepak

Microsoft Most Valuable Professional (MVP) award-winning Database Designer with 5 years of experience in designing, administering, developing & performance tuning relational databases and data warehouse. I possess strong leadership skills experience by serving as the Chapter Leader of Professional Association for SQL Server (PASS) which has around 50 members. I am passionate about solving business problems using my technical skills and hence I am interested in the field of Technology Consulting in Information Management.

Leave a Reply

Leave a comment

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