SQL Server Performance

Log Shipping and backup

Discussion in 'SQL Server Log Shipping' started by arturszcz, Apr 12, 2007.

  1. arturszcz New Member

    Hi,

    First, thanks for help with solution for Reporting server.
    Now I'm getting another problem.

    We have log backup every 2 hours on our production server.
    Now, If I set-up Log Shipping every 1 hour what is going to happened with my normal backup?
    In the other hand normal backup (log backup) can interrupt my log shipping. Am I right?

    I understand that I should make backups of log shipping files to tape and disable my normal log backup job. Of course Full backup can still remain unchanged.
  2. satya Moderator

    Log shipping takes care of transaction logs and will not have any issue on the affect of normal backup.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. arturszcz New Member

    Yes,

    Buy I have to disable Log Backup on my normal backup procedure.
    If not Log Shipping wil fail.
    Am I right.
  4. MohammedU New Member

  5. satya Moderator

    Yes it will invalidate the LSN for multiple log backups and log shipping monitor reports the issues.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. ghemant Moderator

    And in most of the cases it fails due to LSN mismatch so better be careful with this.

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  7. arturszcz New Member

    Thanks again <img src='/community/emoticons/emotion-1.gif' alt=':)' />

Share This Page