Post reply

Log file

  • March 30, 2012 at 1:26 pm

    #254056

    If I do transaction log backup once every few days will it truncate the inactive records (since the operations are minimal)?

    Also, do we need to do full back in order to do transaction log backup? Since our concern is log growth not disaster or recovery point.

    Thanks,

  • March 30, 2012 at 1:32 pm

    #1467163

    If you aren't concerned about doing a point in time recovery, then use the simple recovery model. The only backups available are full and differential. The t-log will be truncated on check point, but that doesn't mean that it may not grow due to unusual activities in the database.

  • March 30, 2012 at 1:50 pm

    #1467169

    Please read through this - Managing Transaction Logs[/url]

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 30, 2012 at 2:19 pm

    #1467186

    since the log file is big, so all i need to change to simple recovery model and issue the truncate command to release the log space.

    Thanks

  • March 30, 2012 at 2:32 pm

    #1467188

    No, the space will be automatically made reusable once you switch to simple recovery. Did you read the article?

    If you're talking about shrinking, first thing you need to do is figure out how large the log needs to be for regular operation. So monitor over a few days and then decide whether or not to shrink and to what size.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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