Home Forums SQL Server 2008 SQL Server Newbies Transaction log-Error 9002 RE: Transaction log-Error 9002

  • December 17, 2015 at 2:02 am

    #1846495

    jacksonandrew321 (12/17/2015)

    Try to run the below Statement:

    DBCC SHRINKFILE(yourdbname_log, 1)

    BACKUP LOG yourdbname WITH TRUNCATE_ONLY

    DBCC SHRINKFILE(yourdbname_log, 1)

    GO

    Beside being appallingly bad advice (shrinking a log to 0 just forces SQL to spend a lot of time and resources growing it back to a useful size, probably creating way too many VLFs in the process), it doesn't work.

    Msg 155, Level 15, State 1, Line 2

    'TRUNCATE_ONLY' is not a recognized BACKUP option.

    Please, don't do this ever.

    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