• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

Transaction Log Backup Error

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
jhadur
Just Arrived
Just Arrived


Joined: 04 Jan 2007
Posts: 0


Offline

PostPosted: Wed Jan 24, 2007 10:43 pm    Post subject: Transaction Log Backup Error Reply with quote

I am getting the following error on our SQL server for our backup job. Any Ideas on how to fix this? I am totally not an SQL person.

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 1/24/2007
Time: 3:01:12 PM
User: N/A
Computer:
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0xD9EBFF34F020714780DC9B93F447746D) - Status: Failed - Invoked on: 2007-01-24 15:00:00 - Message: The job failed. The Job was invoked by Schedule 22 (Schedule 1). 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.
Back to top
View user's profile Send private message
moondoggie
Lurker
Lurker


Joined: 27 May 2005
Posts: 19


Offline

PostPosted: Thu Jan 25, 2007 2:08 am    Post subject: Reply with quote

i've been getting the same warning. there is one of two possibilities in my case. one being that the database being backed up is not set to full recovery mode and the other that the "master" database is not being backed up per microsoft's explicit instructions.

you can find which ones are failing from the backup logs -- don't know the correct path off the top of my head right now. but it will give you a line like "could not process database _____. skipped this step". if there is any name besides "master" there, open up the sql enterprise manager, go to databases, right click the offending database and go to the options tab. if it's set to "simple" then that's probably your problem.

if the "master" database *is* the problem, then try this article:

http://support.microsoft.com/kb/285288/EN-US/
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Looking for more Windows Networking info?

Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing!
View a sample newsletter.

Become a WindowsNetworking.com member!

Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!

Community Area

Log in | Register

Readers' Choice

Which is your preferred data recovery solution?

Follow TechGenix on Twitter