Tuesday, August 24, 2010

SQL 2005 Database Snapshots

Database Snapshot is new concept in SQL Server 2005 and available in Enterprise Edition only. It provides a read-only, "virtual" copy of a database, at a given point in time.

Database Snapshot can work in
  1. Single Server
  2. Database Mirroring
  3. Failover Cluster
Note: Source database and snapshot database must be on the same instance.

More details Database Snapshot:
1. http://www.simple-talk.com/sql/database-administration/sql-server-2005-snapshots/

2.[PPT] Implementing Database Snapshot & Database Mirroring in SQL - Html ...
or www.sqlmvp.com/ppt/p3.ppt

3. DB Mirroring
http://www.emc.com/collateral/hardware/white-papers/h2649-microsoft-sql-srvr-2005-db-mirror-wp-ldv.pdf