SQL Server Performance

Log Shipping - SQL Clustering Environment

Discussion in 'SQL Server Log Shipping' started by pssenthil, Jun 14, 2004.

  1. pssenthil New Member



    Hi all,

    I have configured two node SQL cluster with default instance and SAN as shared disk.
    I have also configured log shipping on primary server which uses maintenance plan to
    backup, copy and restore transaction logs to secondary server in remote location.

    My questions are:

    1) If failover happens, what would be the impact on log shipping?
    2) How would i accomplish the log shipping automation without any interruption even if
    the cluster failover occurs?
  2. satya Moderator

    1) You need to perform LOG SHIPPING ROLE change manually in order to reverse the log backup/restore.

    2) I haven't tried, may wait for others responses.

    Log shipping does require more manual intervention and administration than a clustered solution, because log shipping does not automatically perform the role change required to bring the warm standby online.


    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.
  3. pssenthil New Member


    My question is in the line of cluster nodes failover... not Log shipping role change.

    If the first node failover to second node what would happen to maintenance plan which take the backup of transaction log to log directory for log shipping purpose? will this job continue during failover or stopped?
  4. gary New Member

    If the first node failover to second node what would happen to Log shipping configuration in SQL Server 2005??
    and how to configure log shipping in Clustered SQL Server 2005?
    provide the links for the documentation about How to configure Log shipping in Clustered SQL Server 2005

Share This Page