Advertisement

Database Snapshots

Abstract

One of the most useful and potentially problematic features of SQL Server is the database snapshot. It provides two basic pieces of functionality: 1) a point-in-time view of a database (a data time machine, if you will) and 2) the ability to restore the production database to that point in time extremely quickly. However, a database snapshot is not part of, nor should it ever be a part of, a backup/recovery process. It needs a live database in order to function. It can play an important role in a disaster recovery plan, though.

Keywords

Naming Convention Disaster Recovery Source Database User Error Data Page 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© James Luetkehoelter 2008

Personalised recommendations