Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Transaction log error

Created: 24 Jan 2013 | 6 comments

Hi,

I am trying to find out how to set up transaction log backups given the following message(s) reported using BUE 2012 SQL agent for windows:

V-79-40960-37914 - Database ReportServer is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.

I do not want to set up the backups to Simple mode as these are production servers.

How can I set up the backup to back up the transaction logs?

Thank you

Ken

 

 

Comments 6 CommentsJump to latest comment

Donald Eady's picture

Ken you'll need to add a stage to your backup for incremental log backups running these will truncate the sequal logs... i will edit with screen shots momentarily view best practices document below... note 4th bullet down.. 

 

http://www.symantec.com/docs/HOWTO21793

 
Edit... View SQL log backup SN below 
 

 

I hope this posting was helpful

  

Ken M's picture

Donald,

Please see my comments about needing information on BUE 2012, not 2010. The options in 2012 are limited and not at all like your screen shot from BUE 2010. The link you posted is for 2010 as well, and does not seem to reflect what I am seeing in BUE 2012.

If I am missing something on it could you point me in the right direction?
Thank you

Ken

Ken M's picture

That'll be great Donald! Many Thanks.

Ken M's picture

Donald;

It looks like those options are for BUE 2010 only.With 2012 there are 3 options for creating a new stage- "by method"
1) Incremental=back up only the changes since the last full or incremental backup
2) Differential= back up all changes since the last full backup and
3) Full=back up all data.

Under the SQL options you have the following:

1) Physical Check only
2) None
3) Full check excluding indexes
4) Full Check including indexes
I've looked at both the single instance and the backup job defaults and this is all that is offered in BUE 2012.

Is there one of these I should be using?
Thank you
 

 

Donald Eady's picture

Give me just a few minutes and ill post the shots that youre requesting 

 

I hope this posting was helpful

  

Donald Eady's picture

if you edit your job and add a stage by method add an incremental job 

 

Then on the left near the bottom choose Microsoft SQL and verify that you have log backup enabled

 

Sorry for the confusion earlier... you posted under 12.x not 2012 so i thought that the 2010 screen shot  would be applicable  hope this is more helpful. 

I hope this posting was helpful