question

vivekchandra09 avatar image
vivekchandra09 asked

Maintenance plan, Transaction log backups

My sysadmin has setup backup for a erp database(SQL Server 2008). I looked at the maintenance plan for backup and found that the full database is being backed up daily and the transaction log is being backed just on daily basis. How to change the trn log backup to every 30 minutes or 1 hr.
backuptransaction-logmaintenance-plans
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ASK SQL Server Central runs by you voting. For all helpful answers below, please indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next that answer.
0 Likes 0 ·
JohnM avatar image
JohnM answered
You can change the schedule either through the maintenance plan itself or by finding the job under the SQL Agent menu. In the maintenance plan, if you edit the plan, just next to the Schedule column you'll see a date picker button. Click that and the resulting dialog window will allow you to edit the frequency of the job. Within the SQL Agent job, edit the job, click on 'Schedules' on the left under 'Select a Page'. Edit the current schedule and change the frequency of the job accordingly. Hope that helps!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
Agree with @johnM. You can modify the database maintenance plan as he described, or you and ditch the maintenance plan and implement the SQL Server Maintenance Solution by Ola Hallengren. You can find it detailed [HERE]( https://ola.hallengren.com/). This solution can handle your weekly full, daily differential, and log backups as well as you can enable the jobs for consistency checks, index maintenance and add a parameter to the index maintenance to also do statistics maintenance. I recommend this approach over Database Maintenance plans.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.