Failed transaction log jobs

Question

Failed transaction log jobs

Dony

Ten Centuries

Points: 1317
More actions
September 10, 2007 at 11:13 am

#118560

Hi,

I have a cluster SQL 2000 under Windows server 2003 environment. yesterday, I got two errors in transaction log history. I tried to figure out what was the reason. But the info I get is under the following:
==================================================================================
Event Type:      Warning
Event Source:   SQLAgent$INST01
Event Category:            Job Engine
Event ID:          208
Date:                9/10/2007
Time:                2:00:03 AM
User:                N/A
Computer:        DC1SQL01V01
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 're7, re7_ebc'' (0x012980AF615C56449B0FB9F31AAB3A94) - Status: Failed - Invoked on: 2007-09-10 02:00:00 - Message: The job failed. The Job was invoked by Schedule 35 (Schedule 1). The last step to run was step 1 (Step 1).

For more information, see Help and laceName>SupportlaceName> laceType>CenterlaceType> at http://go.microsoft.com/fwlink/events.asp.

Event Type:      Warning
Event Source:   SQLAgent$INST01
Event Category:            Job Engine
Event ID:          208
Date:                9/10/2007
Time:                1:00:03 AM
User:                N/A
Computer:        DC1SQL01V01
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 're7, re7_ebc'' (0x012980AF615C56449B0FB9F31AAB3A94) - Status: Failed - Invoked on: 2007-09-10 01:00:00 - Message: The job failed. The Job was invoked by Schedule 35 (Schedule 1). The last step to run was step 1 (Step 1).

For more information, see Help and laceName>SupportlaceName> laceType>CenterlaceType> at http://go.microsoft.com/fwlink/events.asp.
================================================================================
So what is the solution for these kinds of errors? any suggestions are appreciate!
Thank you very much in advance.
Don

Viewing 6 posts - 1 through 5 (of 5 total)

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

sqldba-294117 Hall of Fame Points: 3486 More actions · Answer 1

see the Reports log under LOG folder if it is configured to do so. that will give you some more information or post message from Report logs. thx

Dony Ten Centuries Points: 1317 More actions · Answer 2

Dony

Ten Centuries

Points: 1317

September 10, 2007 at 6:29 pm

#732651

if not, how can I configure it? Many thanks!

Don

Viking-204480 SSC Eights! Points: 970 More actions · Answer 3

Please check the ErrorLog in the enterprise manager and look for the error. You can also check in ErrLog.log in the log folder.

For configuring the report, you will want to check box in the reporting tab of maintenance plan.

Once you find the error do post in the forum.

Viking.

Thanks!

Viking

Jim Zippeltoff Valued Member Points: 53 More actions · Answer 4

Hi,

btw, this is SQL Server 2005 thread, you seem to be running 2000

check that your db's are in recovery model = full

Dony Ten Centuries Points: 1317 More actions · Answer 5

Jim,

apologize for it. I will post my investigation here for the last time since I was requested to do so. I am very sorry. Now I have some urgent request to do with my job.

Many thanks.

Don