Post reply

sql server logfile

  • May 22, 2010 at 1:25 am

    #141058

    Hi

    The log file on our database is now in excess of 80GB. I thought that by shrinking the database that this would also shrink the log files to a reasonable level but this does not seem to be the case.

    Please could someone tell me what the best way is to reduce the size of the log file

    Thanks

    Matt

  • May 22, 2010 at 1:55 am

    #1171192

    Full recovery and no log backups?

    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

  • May 22, 2010 at 2:20 pm

    #1171250

    Thaks Gail, I'll check it out

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

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