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 3:15 am

    #1559253

    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