2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
→Daily Maintenance Plan: Added "Reorganise Index Task" transaction log note
(→Daily Maintenance Plan: Moved backup to start) |
(→Daily Maintenance Plan: Added "Reorganise Index Task" transaction log note) |
||
| Line 83: | Line 83: | ||
#* File extension: <code>bak</code> | #* File extension: <code>bak</code> | ||
#* File age: Select as appropriate | #* File age: Select as appropriate | ||
Be aware rhat the '''Reorganise Index Task''' can cause lots of activity to be generated in the transaction log, therefore if your recovery mode is ''Full'' (rather than ''Simple''), the transaction log can grow large very quickly. If performing on a database that's been running for some time this can be an issue. Consider setting the recovery mode to ''Simple'' for the first run, or perform at a time when if your transaction log fills you can recover without too much disruption to applications using the database. | |||
=== Hourly Transaction Log Backup === | === Hourly Transaction Log Backup === | ||