db full backup does not run as part of maintenance plan

db full backup does not run as part of maintenance plan, have full backup
scheduled
to run say 7pm, it does not run, can not find any error logs indicating why
it does
not run, i have reset backup time to say 12pm during day and it runs but
for some
reason it doesnt run at regular time, i have even restarted the
sqlserveragent service but that doesnt seem to be the issue, can a database
maintenance plan get corrupted, should i recreate db maint plan, server is
windows 2000 sql 2000 sp3Where are you looking for errors?
Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest logs.
--
Nik Marshall-Blank MCSD/MCDBA
"Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
> db full backup does not run as part of maintenance plan, have full backup
> scheduled
> to run say 7pm, it does not run, can not find any error logs indicating
> why
> it does
> not run, i have reset backup time to say 12pm during day and it runs but
> for some
> reason it doesnt run at regular time, i have even restarted the
> sqlserveragent service but that doesnt seem to be the issue, can a
> database
> maintenance plan get corrupted, should i recreate db maint plan, server is
> windows 2000 sql 2000 sp3|||i loooked there and there are no files that have been modfified since 9/7/05,
the backup should of run last night 9/8/05, i can find any log files dated
9/08/05
under jobs with EM i see database maintenance plan1 with a status of
Executing Job Step '1(Step 1)'
"Nik Marshall-Blank" wrote:
> Where are you looking for errors?
> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest logs.
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
> > db full backup does not run as part of maintenance plan, have full backup
> > scheduled
> > to run say 7pm, it does not run, can not find any error logs indicating
> > why
> > it does
> > not run, i have reset backup time to say 12pm during day and it runs but
> > for some
> > reason it doesnt run at regular time, i have even restarted the
> > sqlserveragent service but that doesnt seem to be the issue, can a
> > database
> > maintenance plan get corrupted, should i recreate db maint plan, server is
> > windows 2000 sql 2000 sp3
>
>|||Is it backup up to a network share?
Also how long has it been running?
Has it ever run correctly?
Look in current activity to see the command it's executing.
Cancel it and run manually does that work?
Without info from logs you have to just try things.
--
Nik Marshall-Blank MCSD/MCDBA
"Tim Brown" <TimBrown@.discussions.microsoft.com> wrote in message
news:FB311559-ADDB-45B4-A9A1-13888D4F7EAB@.microsoft.com...
>i loooked there and there are no files that have been modfified since
>9/7/05,
> the backup should of run last night 9/8/05, i can find any log files dated
> 9/08/05
> under jobs with EM i see database maintenance plan1 with a status of
> Executing Job Step '1(Step 1)'
> "Nik Marshall-Blank" wrote:
>> Where are you looking for errors?
>> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest
>> logs.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
>> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
>> > db full backup does not run as part of maintenance plan, have full
>> > backup
>> > scheduled
>> > to run say 7pm, it does not run, can not find any error logs indicating
>> > why
>> > it does
>> > not run, i have reset backup time to say 12pm during day and it runs
>> > but
>> > for some
>> > reason it doesnt run at regular time, i have even restarted the
>> > sqlserveragent service but that doesnt seem to be the issue, can a
>> > database
>> > maintenance plan get corrupted, should i recreate db maint plan, server
>> > is
>> > windows 2000 sql 2000 sp3
>>|||Hi,
Looks like you are looking into some wrong directory for Logs. Read the
error log using the belwo command from Query analyzer:-
Xp_readerrorlog
Verify any entries for backup.
If you dont have ; then go to SQL Agent jobs-- there you will be having an
entry for your maintenance plan. Just right click and execute the job
and see the job status; by refreshing the enterprise manager.
Thanks
Hari
SQL Server MVP
"Tim Brown" <TimBrown@.discussions.microsoft.com> wrote in message
news:FB311559-ADDB-45B4-A9A1-13888D4F7EAB@.microsoft.com...
>i loooked there and there are no files that have been modfified since
>9/7/05,
> the backup should of run last night 9/8/05, i can find any log files dated
> 9/08/05
> under jobs with EM i see database maintenance plan1 with a status of
> Executing Job Step '1(Step 1)'
> "Nik Marshall-Blank" wrote:
>> Where are you looking for errors?
>> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest
>> logs.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
>> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
>> > db full backup does not run as part of maintenance plan, have full
>> > backup
>> > scheduled
>> > to run say 7pm, it does not run, can not find any error logs indicating
>> > why
>> > it does
>> > not run, i have reset backup time to say 12pm during day and it runs
>> > but
>> > for some
>> > reason it doesnt run at regular time, i have even restarted the
>> > sqlserveragent service but that doesnt seem to be the issue, can a
>> > database
>> > maintenance plan get corrupted, should i recreate db maint plan, server
>> > is
>> > windows 2000 sql 2000 sp3
>>|||The problem only appears to occur when the "email reporting" feature is enabled
it seems to get hung up in xp_sendmail, with this feature turned off the
backups
run ok daily, with it turned on the backup works but the sql job never
completes
and thus is not run at all the next day, i thought it might be an issue with
mcafee but it still doesnt complete with email reporting turned on, for now
i have
disabled the email reporting feature
"Hari Prasad" wrote:
> Hi,
> Looks like you are looking into some wrong directory for Logs. Read the
> error log using the belwo command from Query analyzer:-
> Xp_readerrorlog
> Verify any entries for backup.
> If you dont have ; then go to SQL Agent jobs-- there you will be having an
> entry for your maintenance plan. Just right click and execute the job
> and see the job status; by refreshing the enterprise manager.
> Thanks
> Hari
> SQL Server MVP
>
> "Tim Brown" <TimBrown@.discussions.microsoft.com> wrote in message
> news:FB311559-ADDB-45B4-A9A1-13888D4F7EAB@.microsoft.com...
> >i loooked there and there are no files that have been modfified since
> >9/7/05,
> > the backup should of run last night 9/8/05, i can find any log files dated
> > 9/08/05
> >
> > under jobs with EM i see database maintenance plan1 with a status of
> > Executing Job Step '1(Step 1)'
> >
> > "Nik Marshall-Blank" wrote:
> >
> >> Where are you looking for errors?
> >>
> >> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest
> >> logs.
> >>
> >> --
> >> Nik Marshall-Blank MCSD/MCDBA
> >>
> >> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
> >> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
> >> > db full backup does not run as part of maintenance plan, have full
> >> > backup
> >> > scheduled
> >> > to run say 7pm, it does not run, can not find any error logs indicating
> >> > why
> >> > it does
> >> > not run, i have reset backup time to say 12pm during day and it runs
> >> > but
> >> > for some
> >> > reason it doesnt run at regular time, i have even restarted the
> >> > sqlserveragent service but that doesnt seem to be the issue, can a
> >> > database
> >> > maintenance plan get corrupted, should i recreate db maint plan, server
> >> > is
> >> > windows 2000 sql 2000 sp3
> >>
> >>
> >>
>
>