Post reply

Log shipping

  • July 20, 2004 at 6:23 am

    #162925

    Hi There

    I am currently log shipping the transaction logs from one server to the other. What I have noticed is that the trn files are constantly a certain size, however somtimes they get bigger. Is this normal? Could it be that vast amounts of data was captured and it is changing the sizes of the trn files that is being dumped for logshipping? Please can someone exlain this to me.

    Thank you in advance.

     

  • July 20, 2004 at 6:34 am

    #515229

    What you'll more than likely find is that there are no tranasctions running against the database for the majority of the time and those times that the logs are bigger are times that coincide with data loads and updates.

    The more transactions that occur in the timeframe between log dumps, the bigger the dumps will be.


    Shamless self promotion - read my blog http://sirsql.net

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

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