Home Forums SQL Server 2008 SQL Server 2008 Administration Size of Log file too big RE: Size of Log file too big

  • November 15, 2012 at 4:03 am

    #1559284

    miazaidi (11/15/2012)

    User would have performed large DML operation, DELETE or UPDATE

    Shrink you database, it will reduce the size of your .ldf as well as .mdf

    USE [DATABASE NAME]

    GO

    DBCC SHRINKDATABASE(N'DATABASE NAME' )

    GO

    No, don't do that. It'll fragment the indexes, cause performance problems and probably won't solve the large log problem

    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