DB_Maintenance Plan error

[sanjdhiman]

Hi there Im getting this error

A quick rundown on how the server is setup

Server is running on Windows 2000. With SP3a on it.
I created the DB_Maint Plan using the wizard and will be deleting the files every 1 week.
Folder settings are correct for where i am backing up to.

I deleted my old maintenace plan and have been trying to sort it that way.

Error Message is as follows.


Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'ACTORUK\ACTORUK' as 'ACTORUK\Administrator' (trusted)
Starting maintenance plan 'actorDB_UK_Total_Maintenance_Plan' on 31/08/2004 11:25:15
[1] Database actorDB_UK: Transaction Log Backup...
Destination: [d:\MSSQL\DATA\MSSQL$ACTORUK\BACKUP\actorDB_UK\actorDB_UK_tlog_200408311125.TRN]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'd:\MSSQL\DATA\MSSQL$ACTORUK\BACKUP\actorDB_UK\actorDB_UK_tlog_200408311125.TRN' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.
Deleting old text reports... 0 file(s) deleted.

End of maintenance plan 'actorDB_UK_Total_Maintenance_Plan' on 31/08/2004 11:25:59
SQLMAINT.EXE Process Exit Code: 1 (Failed)

Emailing report to operator 'systems'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005


Not sure what is going on? Tried to re-create it a few times.

Does anyone know wats up?

Im backing up just one database.

Thanks for your help in advance
Sanj

 

[JayKusch]

The portion of the error that says status = 112 tells me that you are out of space on your D: drive that you are writing your backups to.

Thanks

J. Kusch