Log Shipping Stops Working on Clustered Instance if Failed Over to Another Node - by Allan Hirt

Status : 

 


11
0
Sign in
to vote
ID 559435 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 5/16/2010 4:39:31 AM
Access Restriction Public

Description

If you configure log shipping on a clustered instance where the program files is something other than the main system drive, log shipping stops working once the instance is failed over to another node. The reason is that when the Add Node operation is run on the other node(s), it does not configure the SQL Server instance properly. On the original node, everything is installed properly (for example, Z:\Program Files\Microsoft SQL Server\100\Tools\Binn\SqlLogShip.exe). On the other node, it puts SqlLogShip.exe on the original system drive. The SQL Server Agent job LSBackup_DBName references this as its step:
"Z:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Backup 6B81BF42-4AA8-4DE3-8349-5E54EE0C52ED -server KILROY

So clearly this will not work when things are failed over to another node if SqlLogShip is not where SQL Server is expecting it to be.

See pictures for verification and also check my blog for integrated pics and instructions.
http://www.sqlha.com/blog/post/2010/05/15/Bug-Combining-Failover-Clustering-Log-Shipping-When-Programs-Installed-On-Another-Drive.aspx
Sign in to post a comment.
Posted by Microsoft on 5/20/2013 at 4:03 PM
Hi Allan,

given my previous message, I'm archiving this work item for now.

Best regards
Jean-Yves Devant 

Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Posted by Microsoft on 5/20/2013 at 4:03 PM
Hi Allan,

thanks for taking the time to share your feedback, this is really important to us.
Unfortunately this does not meet the bar now. We do not plan to address this for now. We will revisit the decision if more customers vote for the issue.

Best regards
Jean-Yves Devant 
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Posted by Microsoft on 5/25/2010 at 12:06 PM
Hi Allan,

As we discussed offline, this will be considered as a potential DCR for a future release.

Here is the detail we have for now:

The issue is that the SQL Agent Jobs for Log Shipping have the full path specified in the job step. When the SQL installation is different on clustered nodes, the path to sqllogship.exe will only be valid on one side.

Workaround:

Ensure that the OS path environment variable to sqllogship.exe is in place on all nodes of the cluster. i.e. c:\program files\microsoft sql server\100\tools\binn

Manually edit the Log Shipping jobs, by removing the hardcoded path to sqllogship.exe.

The Log Shipping jobs should work on all nodes after this workaround.

Changing this to a DCR. The shipped log shipping code is by design, but we may consider code changes in next major release of SQL .



Thanks for reporting this issue.

Max Verun
SQL Server