Scheduled Backup Jobs Failing Sporadically

I have 2 types of SQL Server backup jobs that keep failing
sporadically. There are nightly full backups that fail and
there are hourly Transaction Log backups that fail
sporadically as well.
The nightly backups are scheduled for 2:00 a.m. I've just
changed the times and staggered them seconds apart. The
hourly Tlog backups run every hour during the day time.
The only error message I can find is:
Executed as user: KYEANTD\SQLAdmin. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.Executed
as user: KYEANTD\SQLAdmin. sqlmaint.exe failed. [SQLSTATE
42000] (Error 22029). The step failed.
When a job fails I run it manually and the backup works.
These failures are only occuring on SQL Server 2000 SP3You need to specify a report file for your maint plan and look for error messages in that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message
news:046401c3c4e4$5e556c30$a301280a@.phx.gbl...
> I have 2 types of SQL Server backup jobs that keep failing
> sporadically. There are nightly full backups that fail and
> there are hourly Transaction Log backups that fail
> sporadically as well.
> The nightly backups are scheduled for 2:00 a.m. I've just
> changed the times and staggered them seconds apart. The
> hourly Tlog backups run every hour during the day time.
> The only error message I can find is:
> Executed as user: KYEANTD\SQLAdmin. sqlmaint.exe failed.
> [SQLSTATE 42000] (Error 22029). The step failed.Executed
> as user: KYEANTD\SQLAdmin. sqlmaint.exe failed. [SQLSTATE
> 42000] (Error 22029). The step failed.
> When a job fails I run it manually and the backup works.
> These failures are only occuring on SQL Server 2000 SP3|||I've found this error message:
Microsoft (R) SQLMaint Utility (Unicode), Version
[Microsoft SQL-DMO (ODBC SQLState: HYT00)] Error 0:
[Microsoft][ODBC SQL Server Driver]Timeout expired
>--Original Message--
>I have 2 types of SQL Server backup jobs that keep
failing
>sporadically. There are nightly full backups that fail
and
>there are hourly Transaction Log backups that fail
>sporadically as well.
>The nightly backups are scheduled for 2:00 a.m. I've just
>changed the times and staggered them seconds apart. The
>hourly Tlog backups run every hour during the day time.
>The only error message I can find is:
>Executed as user: KYEANTD\SQLAdmin. sqlmaint.exe failed.
>[SQLSTATE 42000] (Error 22029). The step failed.Executed
>as user: KYEANTD\SQLAdmin. sqlmaint.exe failed. [SQLSTATE
>42000] (Error 22029). The step failed.
>When a job fails I run it manually and the backup works.
>These failures are only occuring on SQL Server 2000 SP3
>.
>|||In the past I have found that SQLState42000 usually ment
the server was waiting on resources.
>--Original Message--
>I have 2 types of SQL Server backup jobs that keep
failing
>sporadically. There are nightly full backups that fail
and
>there are hourly Transaction Log backups that fail
>sporadically as well.
>The nightly backups are scheduled for 2:00 a.m. I've just
>changed the times and staggered them seconds apart. The
>hourly Tlog backups run every hour during the day time.
>The only error message I can find is:
>Executed as user: KYEANTD\SQLAdmin. sqlmaint.exe failed.
>[SQLSTATE 42000] (Error 22029). The step failed.Executed
>as user: KYEANTD\SQLAdmin. sqlmaint.exe failed. [SQLSTATE
>42000] (Error 22029). The step failed.
>When a job fails I run it manually and the backup works.
>These failures are only occuring on SQL Server 2000 SP3
>.
>|||Seems like sqlmaint.exe get a timeout during some operation. I can't say why that is, if it is a
long running backup (how big db, do you do backup to network) or some other operation...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
<anonymous@.discussions.microsoft.com> wrote in message
news:087701c3c57a$f6760ec0$a401280a@.phx.gbl...
> I've found this error message:
> Microsoft (R) SQLMaint Utility (Unicode), Version
> [Microsoft SQL-DMO (ODBC SQLState: HYT00)] Error 0:
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
> >--Original Message--
> >I have 2 types of SQL Server backup jobs that keep
> failing
> >sporadically. There are nightly full backups that fail
> and
> >there are hourly Transaction Log backups that fail
> >sporadically as well.
> >
> >The nightly backups are scheduled for 2:00 a.m. I've just
> >changed the times and staggered them seconds apart. The
> >hourly Tlog backups run every hour during the day time.
> >The only error message I can find is:
> >
> >Executed as user: KYEANTD\SQLAdmin. sqlmaint.exe failed.
> >[SQLSTATE 42000] (Error 22029). The step failed.Executed
> >as user: KYEANTD\SQLAdmin. sqlmaint.exe failed. [SQLSTATE
> >42000] (Error 22029). The step failed.
> >
> >When a job fails I run it manually and the backup works.
> >These failures are only occuring on SQL Server 2000 SP3
> >.
> >