Post reply

Tranasaction backup and flushing the log

  • May 18, 2007 at 1:53 am

    #174349

    Can i have the script to backup transaction once in every 15-30 mins which basically writes the committed data to the data file and flushes the log and thereby maintaining it under control.

    Nalini D

  • May 18, 2007 at 8:11 am

    #707461

    There are lots of scripts on the site here that you can search. You run the BACKUP TRANSACTION command to do the backup. You can schedule this to run in SQL Agent every 15 minutes.

  • May 21, 2007 at 1:48 pm

    #707916

    Or, if you prefer to do it from Enterprise Manager, you can run the Maintenance Plan wizard.

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

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