Page 149 - DCAP508_DATABASE_ADMINISTRATION

Unit 10: Database Backup and Restore

Notes
Figure 10.11: Restore Progress Dialog Box

9. When the restore operation completes, the dialog box shown in Figure 10.12 is displayed.
To close it, click OK.

Figure 10.12: Restore Database Complete Confirmation

10.4 Database Snapshots

10.4.1 Meaning of Database Snapshot

A database snapshot is a read-only, static view of a database (the source database). Multiple
snapshots can exist on a source database and always reside on the same server instance as the
database. Each database snapshot is transactionally consistent with the source database as of the
moment of the snapshot’s creation. A snapshot persists until it is explicitly dropped by the
database owner.
Unlike default behavior for user databases, a database snapshot is created with the
ALLOW_SNAPSHOT_ISOLATION database option set ON regardless of the setting of this option
on the primary database or the model system database.
Snapshots can be used for reporting purposes. Also, in the event of a user error on a source
database, you can revert the source database to the state it was in when the snapshot was created.
Data loss is confined to updates to the database since the snapshot’s creation.

!
Caution Reverting does not work in an offline or corrupted database. Therefore, taking
regular backups and testing your restore plan are necessary to protect a database.

Notes Database snapshots are unrelated to snapshot backups, snapshot isolation of
transactions, or snapshot replication.

LOVELY PROFESSIONAL UNIVERSITY 143