Home Forums SQL Server 2008 SQL Server Newbies Log file full-Unaable to run Backup log RE: Log file full-Unaable to run Backup log

  • November 17, 2015 at 5:00 am

    #1840272

    GilaMonster (11/16/2015)

    Steve Jones - SSC Editor (11/16/2015)

    If you can't do anything else, then you can use the WITH TRUNCATE option to clear the log

    Not on SQL 2008. WITH TRUNCATE_ONLY throws an error on all versions of SQL after 2005.

    Good catch, Gail. I totally missed that comment (and forgot about that problem).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.