While Bulk-Logged Recovery is a savior when it comes to managing the transaction
log for data warehouses and systems that include a large amount of bulk operations, it
isn??™t without its downside.
The disadvantage is that point-in-time recovery is not technically possible; you can
only restore to the point of the last transaction log backup. It is still possible to recover
bulk transactions, as long as the transaction log that contains them has been backed up.
While the active transaction log in Bulk-Logged Recovery mode is smaller, the log backups
themselves hold copies of the pages altered during the bulk load process. The result
is potentially large transaction log backups.
CHAPTER 2 n MAKING DATABASE BACKUPS 19
The key to using this mode effectively is to invoke it only when needed, then move
back to Full Recovery mode for point-in-time backup. This is a risky procedure. If you
do choose to move between Bulk-Logged Recovery and Full Recovery, always follow
these steps:
1. Switch from Full Recovery to Bulk-Logged Recovery.
2. Perform your bulk-logged operation.
3. After the bulk-logged operation completes, immediately move back to Full
Recovery mode.
Pages:
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83