Could anybody tell me why this job would be failing based on this log?
Running SQL 2000 SP4.
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server 'servername' as 'domain\username' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 4/25/2006 4:35:16
PM
Backup can not be performed on database 'axdata_live'. This sub task is
ignored.
Backup can not be performed on database 'axdata_test'. This sub task is
ignored.
Backup can not be performed on database 'Northwind'. This sub task is
ignored.
Backup can not be performed on database 'pubs'. This sub task is
ignored.
Deleting old text reports... 1 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan2' on 4/25/2006 4:35:16 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)My guess would be that those databases are in Simple recovery mode and you
are attempting to issue a Log backup. Take out the log backup and it should
work.
Andrew J. Kelly SQL MVP
<bjorgenson@.charter.net> wrote in message
news:1146001380.696610.165740@.g10g2000cwb.googlegroups.com...
> Could anybody tell me why this job would be failing based on this log?
> Running SQL 2000 SP4.
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
> Server 'servername' as 'domain\username' (trusted)
> Starting maintenance plan 'DB Maintenance Plan2' on 4/25/2006 4:35:16
> PM
> Backup can not be performed on database 'axdata_live'. This sub task is
> ignored.
> Backup can not be performed on database 'axdata_test'. This sub task is
> ignored.
> Backup can not be performed on database 'Northwind'. This sub task is
> ignored.
> Backup can not be performed on database 'pubs'. This sub task is
> ignored.
> Deleting old text reports... 1 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan2' on 4/25/2006 4:35:16 PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
No comments:
Post a Comment