O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing Database Snapshots

Database snapshots provide point-in-time data recovery and analysis. They do not provide for standby database access in that the original database must be available, as the data set is built partly from the snapshot files and partly from the original database files. This behavior will become clearer as you read through this section. Database snapshots are useful for recovering from data entry or data processing errors, and they are also beneficial for data reporting.

Database Snapshot Functionality

Database snapshots are created almost instantaneously. This is because the snapshot of the original database contains no data at its initial creation. Instead, SQL Server takes advantage of a technology known as sparse ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required