SQL Server Performance

Log shipping disabled and then enabled

Discussion in 'SQL Server Log Shipping' started by jessie, Aug 16, 2007.

  1. jessie New Member

    Hi,
    Few days ago, we were asked to disable the log shipping until further notice, after an hour something, we were asked to have log shipping backed on. Is it necessary that secondary server need to be overlayed with a copy of primary server due to turned off all log backup and copy job and restore job previously?
    Can anyone give me some ideas?
    Thanks!
    Jessie
  2. ghemant Moderator

    I don't think doing so, you would restart the log shipping process again, only thing to make sure is their will be no LSN mismatch. You can refer what was the last restored Log Backup and then restore immediate Log Backup to your secondary server and then restart your log shipping.
  3. satya Moderator

    If you enable the log shipping it might take sometime to update the secondary server, depending upon the number of transactions piled up on the log.
    Best thing is to stop the log shipping as is, take fresh complete database backup from primary and then apply to secondary. Once this is finished you can continue the log shipping process without any issues.
  4. jessie New Member

    Thanks for all your help!
    Jessie

Share This Page