Schedule - Weekly & Monthly

[seag33k]

What strategy do people use to perform weekly and monthly backups?  Under the job setup, I can see you can choose 1st, 2nd, 3rd, 4th, and Last for a particular day.  I'd like to have my weekly backup every week except for the last week, which should be montly.  Some months have more than 5 weeks for a certain day so I would have to manually select 1 - 4 or 1-3, and then choose Last for the monthly.  Before I do this for an entire year, I thought I'd ask if there is a better way.

Thanks,
Eric

[CraigV · Accepted solution]

Hi eric,

Best way to accomplish this is through using a policy. What this is going to do is automatically set up rules depending on what you want to run on which days (Daily/Weekly/Monthly).

The link below is to an outside website, but it is the best I could find...

http://astolstechblog.blogspot.com/2010/10/create-policy-based-grandfather-father.html

Thanks!

[seag33k]

Thanks for the feedback.  It looks like my initial thought of manually editing the schedules is the only route available.

Thanks!

Eric