Ayuda de vídeo de Screencast
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

SQL Transaction log error

Created: 24 Enero 2013 | 6 comments


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


Comentarios ComentariosIr al último comentario

el cuadro de los Donald Eady

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.. 


Edit... View SQL log backup SN below 

I hope this posting was helpful


el cuadro de los Ken M


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


el cuadro de los Ken M


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

el cuadro de los Donald Eady

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

I hope this posting was helpful


el cuadro de los Donald Eady

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