Post reply

why can't I shrink this log file?

  • December 3, 2011 at 4:03 pm

    #248953

    Hello all

    I hava a database of 15 gb on the mdf and 54gb on the log, both with autogrowth, nobody is using it, still I can't shring that log file, I even tried setting the database offline and then onlone agin just in case there was something running in there but when I shrink the file the size remains the same

    Any ideas?

    Thanks in advance

  • December 3, 2011 at 4:05 pm

    #1416352

    I just noticed the recovery mode wasset to full, I was able to shrink it now

  • December 3, 2011 at 4:36 pm

    #1416358

    Did you take a log backup or did you change to simple recovery?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 3, 2011 at 4:43 pm

    #1416359

    a log backup

  • December 4, 2011 at 2:50 am

    #1416387

    Please read through this - Managing Transaction Logs[/url] and this - http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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