September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Microsoft has kept up its commitment of providing a database engine foundation that can be highly available 7 days a week, 365 days a year. Database snapshots contribute to this goal in several ways:
• They decrease recovery time of a database because you can restore a troubled database with a database snapshot—referred to as reverting.
• They create a security blanket (safeguard) prior to running mass updates on a critical database. If something goes wrong with the update, the database can be reverted in a very short amount of time.
• They provide a read-only, point-in-time reporting database for ad hoc or canned reporting needs quickly (thus, increasing reporting environment availability).
• They create a read-only, ...