Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    3

    Unanswered: Sql server log shipping

    Hi,

    We have a business application using SQL Server 2005 with a considerably big DB size (almost 80GB) . We have configured a DR setup to copy data from primary database (PR) to the DR server with SQL Server LOG SHIPPING method. The PR data is log shipped on an interval of 15 minutes to the DR Sql Server DB. The problem we are facing is at times the transaction log file of the PR server grows beyond a limit and impacts normal application performance resulting in the application becomes non-responsive. To bring it to normal stage we have to then forcefully run Transaction log backup with truncate only command which reduces the transaction log backup size. But then this impacts our DR setup Log Shipping jobs and it breaks/stops to carry out DR log shipping.

    I need help on how to keep the DR setup in sync throughout and keep the transaction log backup at lower space.

    Thanks for you advice.

    Rgds.

    Vijay

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Why not pause the logshipping job(s), take a regular log backup (which will likely truncate the log), and apply that log to the DR server, then restart the logshipping jobs?

  3. #3
    Join Date
    Sep 2004
    Posts
    3
    Hi MCrowley,

    Thx for your reply. Is this the only option available? Can this be automated with some script? (I mean, unfortunately we dont have 24/7 DBA to do this manually). Secondly, will the regular transacion log backup reduce the log file size ?

    Thx in advance for your valuable advice.

    Rgds.

    Vijay

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I would not go so far as to say it is the only method available. I am not even sure it will work, as I have not worked with log shipping in a number of years. Is the problem the size of the log file (which will not be automatically reduced), or the number of entries in the log? How big are the data portion and the log portion, now?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •