Problem
The Transaction Logs are growing exponentially and causing an issue for needed space.
Resolution
Add a Full backup of transaction logs to your maintenance plans.
1. Right Click Maintenance Plans > Maintenance Plan Wizard
2. Name the new plan > Next
3. Check the task for "Back Up Database (Transaction Log)" > Next > Next
4. On the "Define Back Up Database (Transaction Log Task) Configuring the maintenance task", choose "All Databases". > Next
5. Change the location of the report if you want > Next
6. Finish
7. At this point you can manually execute your new plan (Right Click > Execute) or set it to execute on a schedule. Once the logs have been successfully backed up, they will shrink automatically.
Cause
When using the Full Backup Recovery Model for your databases, the transaction logs will continue to grow until they are also backed up.
Comments