Post reply

Reorg job & failing TRN backups

  • October 8, 2006 at 11:03 pm

    #114686

    Noticed the trn backups where failing with error "backup log failed, There is no current database backup".

    In order to save disk space I had a "Reorg Index Task" maintenance plan set up, but preceeded it with a tsql cmd to set recovery model to simple. Then do the reorg task and set recov model back to full. This all worked fine and LDF size did not grow. (btw, this job run after a full backup)

    After this reorg job the maintenance plan to do the TRN backups kept failing.

    Was my approach wrong to set db first to simple when doing a reorg?

     

     

  • October 10, 2006 at 6:15 am

    #664975

    The short answer is yes.  You can not do a transaction log backup of a database set to the simple recovery model.  In this mode, the transaction log is automatically truncated when the transaction is checkpointed, ie written to the database.  Please take a few minutes to read BOL regarding the different recovery models, I think they do a good job describing them.

Viewing 2 posts - 1 through 1 (of 1 total)

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