backups aren't made

Hi,
I'm having some databases on a SQL Server 2000. I made a Database
Maintenance Plan that should make a backup every day in the week.
But for some reason there aren't any backups made (and also no transaction
logs). I tryed alreaddy a whole bunch of stuff: playing with the start date
(to ensure it is before the actual date), describing the directory manually,
changing the hours, rebooting, ...
But nothing seems to work, and it is really frustrating me, hehe.
Does the Maintenance Plan has to be 'started' in a way? Or could this be a
security-question (I'm using local administrator), or does the backups have
to be defined somewhere else also? Or an option somewhere else that blocks
backups? or ...?
Thanks a lot,
PieterHi,
Please ensure that your SQL Agent services is running. Because the Database
maintenance plan create a job internally (During creation of maintenance
plan), which requires SQL Agent service to be up.
Thanks
Hari
MCDBA
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:40162ba6$0$774$ba620e4c@.news.skynet.be...
> Hi,
> I'm having some databases on a SQL Server 2000. I made a Database
> Maintenance Plan that should make a backup every day in the week.
> But for some reason there aren't any backups made (and also no transaction
> logs). I tryed alreaddy a whole bunch of stuff: playing with the start
date
> (to ensure it is before the actual date), describing the directory
manually,
> changing the hours, rebooting, ...
> But nothing seems to work, and it is really frustrating me, hehe.
> Does the Maintenance Plan has to be 'started' in a way? Or could this be a
> security-question (I'm using local administrator), or does the backups
have
> to be defined somewhere else also? Or an option somewhere else that blocks
> backups? or ...?
> Thanks a lot,
> Pieter
>|||Hi:
I just made a backup schedular and the task does not work.
After I check more carefully, I found that I forget to click the
checkbox for the "schedular"
If you do not mark it, it will work the time you click finish but will
not run as a schedular.
Best Wishes
Wei Ci Zhou
"DraguVaso" <pietercoucke@.hotmail.com> wrote in message
news:40162ba6$0$774$ba620e4c@.news.skynet.be...
> Hi,
> I'm having some databases on a SQL Server 2000. I made a Database
> Maintenance Plan that should make a backup every day in the week.
> But for some reason there aren't any backups made (and also no transaction
> logs). I tryed alreaddy a whole bunch of stuff: playing with the start
date
> (to ensure it is before the actual date), describing the directory
manually,
> changing the hours, rebooting, ...
> But nothing seems to work, and it is really frustrating me, hehe.
> Does the Maintenance Plan has to be 'started' in a way? Or could this be a
> security-question (I'm using local administrator), or does the backups
have
> to be defined somewhere else also? Or an option somewhere else that blocks
> backups? or ...?
> Thanks a lot,
> Pieter
>|||Hm, thanks: the SQL Agent was indeed not running, hehe.
It's running now, so I hope it will work now. I'll see tomorow morning, hehe
:-)
Thanks!
Pieter
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:u$9gkiL5DHA.2628@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Please ensure that your SQL Agent services is running. Because the
Database
> maintenance plan create a job internally (During creation of maintenance
> plan), which requires SQL Agent service to be up.
> Thanks
> Hari
> MCDBA
> "DraguVaso" <pietercoucke@.hotmail.com> wrote in message
> news:40162ba6$0$774$ba620e4c@.news.skynet.be...
> > Hi,
> >
> > I'm having some databases on a SQL Server 2000. I made a Database
> > Maintenance Plan that should make a backup every day in the week.
> >
> > But for some reason there aren't any backups made (and also no
transaction
> > logs). I tryed alreaddy a whole bunch of stuff: playing with the start
> date
> > (to ensure it is before the actual date), describing the directory
> manually,
> > changing the hours, rebooting, ...
> >
> > But nothing seems to work, and it is really frustrating me, hehe.
> >
> > Does the Maintenance Plan has to be 'started' in a way? Or could this be
a
> > security-question (I'm using local administrator), or does the backups
> have
> > to be defined somewhere else also? Or an option somewhere else that
blocks
> > backups? or ...?
> >
> > Thanks a lot,
> >
> > Pieter
> >
> >
>