Post reply

LOG FILE SIZE

  • April 17, 2011 at 12:31 am

    #142468

    I AM USING SQL SERVER 2005.

    mY WHOLE DATABASE SIZE IS ABOUT 5 GB.

    bUT LOG FILE SIZE IS ABOUT 17.5 GB.

    hOW CAN I REDUCE LOG FILE SIZE ?

  • April 17, 2011 at 1:00 am

    #1312495

    Database is in Full recovery model and you are not taking t-log backup right?

    M&M

  • April 17, 2011 at 1:57 am

    #1312497

    You may find this article[/url] useful.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • April 17, 2011 at 4:11 am

    #1312501

    Yes correct.

  • April 18, 2011 at 7:12 am

    #1312729

    If I had a nickel for all the times I have seen this kind of post . . . 😀

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

  • April 18, 2011 at 9:42 pm

    #1313161

    Hi Dude

    1st check this

    select name,log_reuse_wait_desc from sys.databases

    it will show reason why ur log is not getting reused

    if it shows 'Log Backup' and then take log backup and shrink

    if it is not get shrinked then execute above select stmt

    actually ur log size is too much u need to take another log backup

    and then shrink

    apply same untill u get desired log size

    if LOG_REUSE_WAIT is Replication

    and database is not in replication

    then

    sp_removedbreplication 'DB_name'

    and finally shrink it

Viewing 6 posts - 1 through 5 (of 5 total)

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