• subscribe
February 22, 2006 12:00 AM

What’s a Snapshot?

SQL Server Pro
InstantDoc ID #48962

What are snapshots and what are their benefits and drawbacks?

There are multiple types of snapshot (e.g., snapshot replication, database snapshot, snapshot isolation level). I assume you mean database snapshots, which are designed to present a point-in-time, read-only copy of a database. Snapshots are especially-beneficial when you're using report suites that need a stable view of the data. As data changes, the original pages are added to the snapshot. This process, also known as "copy on right," can cause the performance of a database snapshot to decline slightly over time.

—Patrick Conlan
Platform Program Manager
Microsoft Project Team

 



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...