Alex Gordon

Asked: 2010-09-23 11:30:16 +0800 CST2010-09-23 11:30:16 +0800 CST 2010-09-23 11:30:16 +0800 CST

how do i do edit the frequency of backups in sql server?

772

i already have existing maintenance plans and i would like to edit the frequency at which they occur. is this possible to do?

2 Answers

Voted

joeqwerty
2010-09-23T12:35:17+08:002010-09-23T12:35:17+08:00
Sure, you can either modify the properties of the maintanance plan or you can modify the properties of the job that comprises the maintenence plan.
2
Sean Howat
2010-09-23T12:34:03+08:002010-09-23T12:34:03+08:00
In SQL Server Management Studio open up the maintenance plan folder in the left pane. Choose the maintenance plan you want to modify by right-clicking and choosing modify. There should be a calendar button that you can click on for each subplan where you can set the frequency and time the job will run.
1

Web Analytics Made Easy - Statcounter