Home Forums SQL Server 2012 SQL 2012 - General SQL2012SP1, simple recovery, transaction log full, can't add another, won't grow RE: SQL2012SP1, simple recovery, transaction log full, can't add another, won't grow

  • May 16, 2013 at 8:29 am

    #1615827

    f242337 (5/16/2013)

    f242337 (5/15/2013)

    re: TEMPDB

    My tempdb data has 19MB allocated of which 13MB is free, and its log has 5MB allocated of which 2MB is free.

    DBCC LOGINFO shows it has 18 VLFs of which 4 are status 2, and the others are all status 0.

    That is not nearly enough space to do anything. You need to increase the size of your tempDB, or move it to a bigger hard drive.

    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.