Database Snapshot in Sql Server 2005

Posted on C# Corner See other posts from C# Corner
Published on Apr 26, 2010 Indexed on 2010/04/26 15:04 UTC
Read the original article Hit count: 288

Filed under:
A database snapshot is a read-only, static view of a database (called the source database). Each database snapshot is transactionally consistent with the source database at the moment of the snapshot's creation. When you create a database snapshot, the source database will typically have open transactions. Before the snapshot becomes available, the open transactions are rolled back to make the database snapshot transactionally consistent.

© C# Corner or respective owner