Page 133 - DCAP508_DATABASE_ADMINISTRATION

Unit 9: Database Recovery Models

Users are currently not allowed in the database. Notes
No modifications are made during bulk processing that are not recoverable without
depending on taking a log backup; for example, by re-running the bulk processes.

We recommend that:
Before switching to the bulk-logged recovery model, you back up the log.
This is important because, under the bulk-logged recovery model, if the database fails, backing
up the log for bulk operations requires access to the data.
After performing the bulk operations, you immediately switch back to full recovery
mode.

After switching back from the bulk-logged recovery model to the full recovery model,
you back up the log again.
Following these recommendations fully protects your data and enables point-in-time recovery.
The following figure illustrates these recommendations.

Figure 9.1: Recovey Model of a Database

When switching between two recovery models, your backup strategy remains the same: continue
performing periodic database, log, and differential backups.

9.4.6 Switching from Full or Bulk-Logged to Simple Recovery

Switching from the full or bulk-logged recovery to simple recovery is possible, but uncommon.
Back up the transaction log just before switching to the simple recovery model, to permit
recovery to that point. Backing up the log is not supported under the simple recovery model, so,
after switching, discontinue any scheduled jobs for backing up the transaction log.

Task Describe the procedure of Switching Between Full and Bulk-Logged Recovery

LOVELY PROFESSIONAL UNIVERSITY 127