Page 159 - DCAP508_DATABASE_ADMINISTRATION

Unit 10: Database Backup and Restore

The data file (a file restore): A data file or a set of files is restored and recovered. During a Notes
file restore, the filegroups that contain the files are automatically offline for the duration
of the restore. Any attempt to access an offline filegroup causes an error.
A database snapshot is a read-only, static view of a database (the source database). Database
snapshots are dependent on the source database. The snapshots of a database must be on the
same server instance as the database. Database snapshots operate at the data-page level. To
the user, a database snapshot appears never to change, because read operations on a database
snapshot always access the original data pages, regardless of where they reside.

10.6 Keywords

Database Snapshot: A database snapshot is a read-only, static view of a database (the source database).

Differential Backup: A differential backup is based on the latest full backup of the data. This is
known as the base of the differential, or the differential base. A differential base is a full backup
of read/write data.

Differential File Backup: A backup of one or more files that contain data extents that were
changed since the most recent full backup of each file.
Differential Partial Backup: A backup that contains only the data extents that were modified
since the most recent partial backup of the same set of filegroups.
File Backup: A full backup of all the data in one or more files, or filegroups.
Full Backup: A full backup contains all the data in a specific database or set of filegroups or files,
and also enough log to allow for recovering that data.
Partial Backup: A backup of all the full data in the primary filegroup, every read/write filegroup,
and any optionally specified read-only files or filegroups. A partial backup of a read-only
database contains only the primary filegroup.

10.7 Review Questions

1. Briefly describe various types of backup strategies
2. Discuss the back media available in SQL server.
3. Explain the concept of database snapshot.
4. Describe the advantages and disadvantages of database snapshot.
5. Explain the basic uses of database snapshot.

6. Comment on the following statement: Effect of the Update Pattern on Database Snapshot
Growth.
7. Describe the process of creating database snapshots.

8. Explain in detail the procedure to perform a complete database backup through SQL
Server Enterprise Manager.
9. Discuss how to restore a complete database backup to same database.

Answers: Self Assessment

1. Full backup 2. Differential backup
3. Partial Backup 4. Differential Partial Backup

LOVELY PROFESSIONAL UNIVERSITY 153