SQL Server Performance

detach db on primary will affect log shipping?

Discussion in 'SQL Server Log Shipping' started by fudiu, Apr 19, 2005.

  1. fudiu New Member

    Log shipping is now configured. If the primary server is detached and attached again, will it affect the log shipping maintenance plan
  2. satya Moderator

    Yes in order to enable the log shipping you must perform the role reversal or continue by restoring full backup from primary to secondary.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page