Database Snapshots in SQL Server 2005

Wednesday Nov 29th 2006 by Staff

One of the brand new features in SQL Server 2005 is the database snapshot. Arvinder Singh Khosla and S.Srivathsani Murthy bring us a look at how these static view databases can be setup and used in your environment.

[From SQL Server Central]

Database snapshots is a new feature added in SQL Server 2005.Database Snapshot can be used to create a read-only copy of the database. Database snapshot consists of the read-only static view of the database without including the uncommitted transactions. The uncommitted transactions are rolled back to make the database snapshot transactionally consistent.

The article continues at

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved