Database Snapshots in SQL Server 2005

Wednesday Nov 29th 2006 by DatabaseJournal.com Staff
Share:

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 http://www.sqlservercentral.com/columnists/akhosla/2733.asp

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