Post reply

log file growth

  • May 22, 2016 at 11:37 pm

    #319024

    I could find my DBs log file growth is huge and it reached 100GB now with 90% utilization rate, Currently there are no active transaction so I trigerred a full backup and it reduced the utilization. Can anyone tell me why full backup reduces log file utilization.. I couldn't understand that

    My Db is in simple recovery model

  • May 23, 2016 at 1:48 am

    #1880683

    Did you recently switch from full to simple?

    If you had no long-running active transactions that does not make sense.

    Great explanation on tran logs here (http://www.sqlshack.com/beginners-guide-sql-server-transaction-logs/[/url])

  • May 23, 2016 at 6:29 am

    #1880716

    How often are you backing up your database?

    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.

  • May 23, 2016 at 8:13 am

    #1880776

    Did anyone adjust the checkpoint interval?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply