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:17 am

    #1559255

    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

    Why shrink database when the OP said it was the log?

    Also you do know the implications of shrinking a database?