SQL Server 2005 - Backup Log Failure
Posted on 2010-09-15
I am running SQL Server 2005 on Windows 2003 Standard. I have a maintenance plan with two subplans. The first subplan runs nightly and performs a full backup of all user databases. The second subplan runs hourly and performs a backup of the transaction logs for all user databases. I am getting the following error in the Application Log:
BACKUP failed to complete the command BACKUP LOG OPC. Check the backup application log for detailed messages.
This same error shows up in the SQL Logs, but I'm not sure where to find the 'backup application log'. Can anyone shed some light on this error? I've got four databases on this server, and all four are defined in the maintenance plan but only this one is throwing the error.
A little more information: This database had a log file of over 24Gb and was filling the data drive. Last night I backed up the log file to another disk, then ran a SHRINKFILE and a BACKUP LOG <yourdatabasename> WITH TRUNCATE_ONLY. This reduced the log file to about 20Mb. Not sure if these commands affected the nightly maintenance plan.