Question

Locked

Transaction Log Backup Job for DB Maintenance Plan failing

By buschman_007 ·
Okay so in my SQLSERVER event logs I get two recurring app errors everyday:

Source: SQLSERVERAGENT
Category: Job Engine
Event IT: 208
Type: Warning
Computer: SQLSERVER
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'Acorn System DB Maintenance Plan'' (0x174AFBA65B9C6044AD6B4CD6B33C564F) - Status: Failed - Invoked on: 2008-11-13 00:00:00 - Message: The job failed. The Job was invoked by Schedule 27 (Schedule 1). The last step to run was step 1 (Step 1).


Source: SQLSERVERAGENT
Category: Job Engine
Event IT: 208
Type: Warning
Computer: SQLSERVER
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'Acorn User DB Maintenance Plan'' (0x3C924520A8A79F4FB137C173A92CF347) - Status: Failed - Invoked on: 2008-11-12 20:30:00 - Message: The job failed. The Job was invoked by Schedule 23 (Schedule 1). The last step to run was step 1 (Step 1).


(One job Acorn System DB and the other Acorn User DB)


So I go to SQL Enterprise Manager, navigate to SQL Server Agent->Jobs and you see the only two jobs with Red X's are:

Transaction Log Backup Job for DB Maintenance Plan 'Acorn System DB Maintenance Plan'
&
Transaction Log Backup Job for DB Maintenance Plan 'Acorn User DB Maintenance Plan'


If I click on the step tab there is only 1 step for both of these jobs. Here is the command respectively:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 868AAC8F-C1EE-4A5D-9C4C-24552D367ABB -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\Acorn System DB Maintenance Plan6.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog -UseDefDir -DelBkUps 1WEEKS -BkExt "TRN"'

&

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 4DFC3A06-5C54-42EE-B264-30171C4343CC -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\Acorn User DB Maintenance Plan6.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "C:\SQLBackups" -DelBkUps 3DAYS -BkExt "TRN"'

They might as well be speaking ancient greek at this point!


But I read a suggestion to highlight the DB listed(master) plug the command into SQL Query Analyzer. here is what I get, respectively:

*********************
(39 row(s) affected)

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
*********************
&
*********************
(121 row(s) affected)

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
*********************


I have also gone to DB Maintenance Plans right clicked on the two plans and selected Maintenance Plan History. They both basically say the same thing:


-DB:ACM | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:07pm | Message: Backup Destination: [C:\SQLBackups\ACM_tlog_200811131546.TRN]
-DB:ACM | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:07pm

-DB:Acorn | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:08pm | Message: Backup Destination: [C:\SQLBackups\Acorn_tlog_200811131546.TRN]
-DB:Acorn | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:08pm

-DB:Acttest | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:09pm | Message: Backup Destination: [C:\SQLBackups\Acttest_tlog_200811131546.TRN]
-DB:Acttest | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:09pm

-DB:B2BProgramData | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:11pm | Message: Backup Destination: [C:\SQLBackups\B2BProgramData_tlog_200811131546.TRN]
-DB:B2BProgramData | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:11pm

-DB:Projects | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:13pm | Message: Backup Destination: [C:\SQLBackups\Projects_tlog_200811131546.TRN]
-DB:Projects | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:13pm

-DB:Projects_Direct | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:13pm | Message: Backup Destination: [C:\SQLBackups\Projects_Direct_tlog_200811131546.TRN]
-DB:Projects_Direct | Activity:Backup transaction log | Status: Check | End date: 11/13/08 3:46:13pm

-DB:Projects_DMI | Activity:Backup transaction log | Status: Fail | End date: 11/13/08 3:46:13pm | Message: Backup can not be performed on this database. This sub task is ignored

-DB:Projects_Filltek | Activity:Backup transaction log | Status: Fail | End date: 11/13/08 3:46:13pm | Message: Backup can not be performed on this database. This sub task is ignored

-DB:Projects_P2000 | Activity:Backup transaction log | Status: Fail | End date: 11/13/08 3:46:14pm | Message: Backup can not be performed on this database. This sub task is ignored

-DB:Projects_Strategic | Activity:Backup transaction log | Status: Fail | End date: 11/13/08 3:46:14pm | Message: Backup can not be performed on this database. This sub task is ignored

-DB:Projects_US | Activity:Backup transaction log | Status: Fail | End date: 11/13/08 3:46:14pm | Message: Backup can not be performed on this database. This sub task is ignored

No idea why they start failing at Projects_DMI.


I'm not very versed in SQL, so please be forgiving if I miss obvious things. Also if you have suggestions, remember my experience level is next to nothing with SQL.

Thanks so much to anyone who can shed some light on this issue.

Mike

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

I had the same issue.

by r8tdr In reply to Transaction Log Backup Jo ...

Check this site out.

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic15129.aspx

I performed a cleanup last week and change the names on one of the database, figuring that wouldn't hurt anything as it should, then I changed that specific database to a SIMPLE instead of FULL - it went downhill from there.

Collapse -

Whoa..

by Shellbot In reply to I had the same issue.

You can't just go changing names on databases...

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums