barkingdog


We have been running a backup plan (created using the sql 2005 Maintenance wizard) for some time. It failed last night but all databases seemed to be backed up.

I looked at the ERRORLOG in <mssql2005>\mssql.1\log as well as

"Servname DB Backup Plan_20070118184358.txt"

but found no errors. Where else can I look to see what went wrong

TIA,

barkingdog




Re: Nightly Maintenance Backup Plan fails -- no trace of why

Kuntal Loya - MSFT


You can also check the logs of the Sql Server Agent job corresponding to the maintenance plan.

Thanks,

Kuntal






Re: Nightly Maintenance Backup Plan fails -- no trace of why

barkingdog

>>> check the logs of the Sql Server Agent job

Where are these located (Are you referring to SQLAgent.OUT It had nothing of interest.)

Barkingdog






Re: Nightly Maintenance Backup Plan fails -- no trace of why

Kuntal Loya - MSFT

In Sql 2005, for every maintenance plan an Sql Agent job is created by the same name. You can view its logs as Sql Server Agent -> Jobs -> select the job & right click to View History.

Hope that helps

Kuntal





Re: Nightly Maintenance Backup Plan fails -- no trace of why

Satya SKJ

What was the error under the scheduled job for this maintenance plan

Also try to run thsi manually from SSMS to see the execution, also ensure the SQLAgent account has required privileges to run this job. ALso check what changes have been since last time when this job was running succesfsully.