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 ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
