error code 208 during maintenance plan Translog backups

Question

error code 208 during maintenance plan Translog backups

Matt Rose

SSC-Addicted

Points: 425
More actions
August 25, 2006 at 4:42 pm

#114225

Hey all,
During my maintenance plan which backs up the transaction logs, I continue to get a warning that reads :
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 8/24/2006
Time: 9:30:46 PM
User: N/A
Computer: IMCNJAPP2
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'SLIM_Backup'' (0xACB563C3F3F2F347931D90CD69B95604) - Status: Failed - Invoked on: 2006-08-24 21:30:22 - Message: The job failed. The Job was invoked by User IMCLONE\MatthewRose. The last step to run was step 1 (Step 1).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 8/24/2006
Time: 9:30:46 PM
User: N/A
Computer: Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'SLIM_Backup'' (0xACB563C3F3F2F347931D90CD69B95604) - Status: Failed - Invoked on: 2006-08-24 21:30:22 - Message: The job failed. The Job was invoked by User . The last step to run was step 1 (Step 1).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I've verified the logs and the logs seem to show that it does back them up. There are mltiple databases within this plan, and it appears all of them show up. Any ideas are well appreciated, this is not the only SQL server I have this issue with.
I am running only SP3 and not SP4. Besides that i'm not sure what this could be. Please let me know.
August 28, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

What do you see in the SQL Server log at the time the backup failed? How about the job history details? Right-click on the job in Enterprise Manager and select "view job history".

Greg

SQLBill SSC Guru Points: 51440 More actions · Answer 2

And when you select View Job History, the next part is to check the box.."Show Job Steps". That way you can see the exact step that failed.

Quick guess.......you are probably doing tlog backups of the system databases. You cannot do tlog backups of any database that are in SIMPLE mode. And no matter what, you can not do log backups of the Master database (per the BOL)

-SQLBill