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