Post reply

Simple Database

  • November 24, 2012 at 1:31 am

    #271149

    I have a Database it simple recovery and ı get differential backup every 15 minutes

    but it growth about 30 gb why it does not truncate and

    Can I truncate it with shirink file?

  • November 24, 2012 at 2:07 am

    #1561962

    I assume you mean the log file...

    It does get truncated, every time a checkpoint runs. Truncate means make log space reusable, not make log file smaller. The only thing that makes a log file smaller is a shrinkfile. Yes, you can shrink it. Should you shrink it is the question. If the log file needs to be 30GB, I'd leave it there. If it's grown after unusual activity, then do a once-off shrink (not scheduled, never schedule a shrink operation)

    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

  • November 24, 2012 at 2:12 am

    #1561964

    Thanks after i wrote post i think the same if log file need to growth it affect the performance

  • November 24, 2012 at 10:27 am

    #1561982

    A large log file does not in and of itself cause perforance problems. If a log file fills and has to grow, it will slow down any data modifications occuring at the time.

    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 4 posts - 1 through 3 (of 3 total)

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