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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment