Log Shipping – SQL Clustering Environment | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Log Shipping – SQL Clustering Environment

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?
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.

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?
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

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |