Post reply

Transaction Log Backup Script

  • December 12, 2012 at 8:20 am

    #268090

    Hello Everyone,

    I’m looking for a good script that will let me backup Transaction Log every 30 min into a daily files for each backup into one file. And then delete the file after some days.

    Thank you

    Dan

  • December 12, 2012 at 8:23 am

    #1567912

    Bad idea, you should be backing up every 30 minutes to a new file, not to a big file for that particular day, as should anything happen to that file, the whole media is rendered useless.

    What I would recommend is use Ola's scripts, (link can be found in my signature) which are pretty sophisticated.

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

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