Post reply

How do i configure my sql server logs.

  • May 19, 2009 at 7:39 am

    #996958

    I am betting this is a database that has been in FULL recovery mode forever and has never had a transaction log backup. This is a VERY common problem - we see it several times a week over on the sql server news group.

    you can run dbcc sqlperf(logspace) to see how full tlogs are.

    I recommend backing up the tlog, then doing dbcc shrinkfile (can be done graphically from SSMS or using a script - see Books Online) to shrink it to say equal the size of the database. Just do this the one time! see here: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

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

  • May 20, 2009 at 9:38 pm

    #998060

    Hi,

    A many thanks for all of you guys.... the knowledge and information shared which in one way or another made a great help for me and the rest of the newbies. I will be now doing what you'd taught. A high five for all of you.

    Best,

    Ching

Viewing 2 posts - 16 through 16 (of 16 total)

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