Scheduling Subscription On Day 30 of a Month

I tried to setup a monthly subscription, to be run on Day 30 of a month.
After clicking the radio button for "Month", then click the radio button for
"On Calendar Days", then enter the day 30, and press OK. The subscription
will return the following error message:To create a schedule that runs on
multiple days, you must choose which days to use.
This message will not appear, if I enter any other day, up to and including
day 29.I have to deselect Month of Februrary, which does not have 30 days
"LBJOHN" wrote:
> I tried to setup a monthly subscription, to be run on Day 30 of a month.
> After clicking the radio button for "Month", then click the radio button for
> "On Calendar Days", then enter the day 30, and press OK. The subscription
> will return the following error message:To create a schedule that runs on
> multiple days, you must choose which days to use.
> This message will not appear, if I enter any other day, up to and including
> day 29.
>

schedule a backup?

I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
"To schedule a backup, click schedule".
I don't see a "schedule" button anywhere.
I created a schedule under the agent (I didn't create a job, just a
schedule) but I still don't see an option to schedule the backup.
Any ideas?
Thx
Hello,
For database backup use maintenance plan from SQL Server management studio.
Connect to SQL Server from management studio, expand and choose the
management option,
Maintenance plans.. right click and choose maintenance plan Wizard. This
will help you to do the step by step process to define a backup procedure
and schedule it.
Thanks
Hari
"Tmack" <Terry.McKenna@.gmail.com> wrote in message
news:1173916162.338108.140150@.n59g2000hsh.googlegr oups.com...
> I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says
> "To schedule a backup, click schedule".
> I don't see a "schedule" button anywhere.
> I created a schedule under the agent (I didn't create a job, just a
> schedule) but I still don't see an option to schedule the backup.
> Any ideas?
> Thx
>
|||On Mar 14, 10:09 pm, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> For database backup use maintenance plan from SQL Server management studio.
> Connect to SQL Server from management studio, expand and choose the
> management option,
> Maintenance plans.. right click and choose maintenance plan Wizard. This
> will help you to do the step by step process to define a backup procedure
> and schedule it.
> Thanks
> Hari
> "Tmack" <Terry.McKe...@.gmail.com> wrote in message
> news:1173916162.338108.140150@.n59g2000hsh.googlegr oups.com...
>
>
>
>
> - Show quoted text -
Thanks, this is what I needed.