SQL backup error

[Middlesbrough]

I have a maintenance plan failure. Here are the output file. Where can I
> trouble shoot or why has it failed. But on next schedule, next day it works ?
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
> Server 'HACSSDB004' as 'IHESS\srvsql002' (trusted)
> Starting maintenance plan 'EBFLOW' on 3/16/2005 10:56:17 AM
> [1] Database EFLOW: Database Backup...
> Destination:
> [D:\Mssql\MSSQL\BACKUP\EFLOW\EFLOW_db_200503161104.BAK]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Write on
> 'D:\Mssql\MSSQL\BACKUP\EFLOW\EFLOW_db_200503161104.BAK' failed, status
> = 112. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
> terminating abnormally.
> End of maintenance plan 'EBFLOW' on 3/16/2005 11:23:13 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)

 

[SQLBill]

> 'D:\Mssql\MSSQL\BACKUP\EFLOW\EFLOW_db_200503161104.BAK' failed, status
> = 112. See the SQL Server error log for more details.

So, what does the SQL Server Error log say? Did you look for related error messages in the Windows Event Viewer logs?

If I had to guess, I would say that there was a tape backup job running and copying the backup file at the same time that you were trying to write to it.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

What does the errorlog say?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com