Post reply

Maintenance Plan - backing up trans logs not working

  • March 22, 2006 at 7:53 am

    #112294

    I am trying to back up the log files on SQL 2005 every hour. When I create a maintenance plan specifying this and then save and try view sql there is no code displayed. If I try to run it obviously nothing happens. I have tried creating a new plan and still no luck. Is this a known issue? or is it because maybe no new transactions happened in the last hour.

    I have thought of creating the sql commands manually, but to do this for each hour and each database, just seems not a very clean way to do things.

    Any advice?

    Thanks!

  • March 23, 2006 at 1:19 am

    #628284

    The databases were in simple recovery mode. I changed them to full recovery mode, but to run the log backup successfully had to re-run a full backup while the database was in full recovery.

     

    thanks

  • March 23, 2006 at 1:45 am

    #628285

    yes !! for taking transaction log backup, your database recovery mode should be Full.

    Noman

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

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