Post reply

Backup Issues

  • February 13, 2008 at 2:43 am

    #186750

    Hi every one I'm running a 25GB database. Initially I was doing a Full Backup (Full model) and Differential every 4 hrs. A week after implimenting that Transaction Log went up to 64GB which was a problem. Then recovery model was changed back to Simple and auto growth turned off. everything was back to normal. I want to go back to Full model and have Full backup and Trunsaction Log every 20 min. This will help me to go to a point in time. But my fears are the Log will start to grow again and If i truncate it I won't be able to go back to a point in time. Can any one help me

  • February 13, 2008 at 7:55 am

    #777843

    You won't have that problem with log backups because they truncate the log. There are 2 ways to keep your log trimmed.

    1. Use simple mode. This will truncate the log when the DB checkpoints.

    2. Use Full mode with log backups. When the log backup happens, the log gets truncated. So your logs will truncate every 20mins.

    In your Diff backup scenario, you would have needed to add log backups to the scenario and you would've been fine. But if you don't have bulk ops then Full mode with log backups is better.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • February 13, 2008 at 8:04 am

    #777852

    Thanks a lot

  • February 13, 2008 at 8:48 am

    #777887

    Do you have a second standby server if so try implementing log shipping there.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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