Follow

Backup MSSQL Transaction Logs

Created by: April Humberd
Created date:
Last Updated date:

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk