Post reply

Logshipping + LOG file size increase

  • November 15, 2010 at 2:52 pm

    #157315

    Hello,

    I am using Logshipping in Sql Server 2005, on my primary server logshipping is configured for every 15 minutes frequency. I have no problem in shipping logs to secondary server.

    The problem i am facing is, my Transaction log file is having bigger size than actual size of the database for ex: my Database size is 16GB and transacion log size is 45 GB.

    Did any one faced this problem before? any suggestions will be highly appreciated.

  • November 15, 2010 at 10:11 pm

    #1251091

    I think something else caused the log file growth, not log shipping.

    Check the % space used in the log file. If it is very small, you can shrink it. But monitor it for at least a week. If it again grows to this size, don't shrink it again. Leave it like that.

    Also, create a SQL Agent job to daily email you the file size and % used.

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

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