Friday, March 9, 2012

Error in Maintenance Plan

This is what I get on one of my DB backups:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
[Microsoft][ODBC SQL Server Driver][SQL Server]Write
on 'u:\RBMIChevron\RBMIChevron_db_200311131530.BAK'
failed, status = 121. See the SQL Server error log for
more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
DATABASE is terminating abnormally.
AND I have it set to delete after (1) day old and that
fails also. The permissions are fine.
Any help?
Thanks.And as the message indicates, what are the details in the
SQL Server error log?
In terms of the deletes not working, that can happen for
different reasons - generally where the file is in use
(other backups, anti-viruse, etc). It can also happen on Win
95, 98 and ME.
-Sue
On Thu, 20 Nov 2003 06:15:08 -0800, "Rscott"
<rrscott21@.yahoo.com> wrote:
>This is what I get on one of my DB backups:
>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Write
>on 'u:\RBMIChevron\RBMIChevron_db_200311131530.BAK'
>failed, status = 121. See the SQL Server error log for
>more details.
>[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
>DATABASE is terminating abnormally.
>AND I have it set to delete after (1) day old and that
>fails also. The permissions are fine.
>Any help?
>Thanks.

No comments:

Post a Comment