I have two servers, one is a clone of the other (Hardware and Software) and restored from a baremetal backup. Both servers are on different networks. Both servers are part of a domain with the same name and setup - you get the idea - clones.
I want to set up log shipping between the two servers in order to provide a warm standby for planned maintenance of the 'primary' server.
Does anyone know if it is indeed possible to setup log shipping between two servers that are apparently identical, or does log shipping rely upon the SQL server names being different.
I have recreated this setup in a virtual lab so I can play. So far I have established the following;
- Private network connection between the SQL servers over a separate network card
- Private non-routable IP address for each server
- Local NT User account on both servers with the same password
- Local folder (C:\Shipping) shared out to the local shipping user account and domain SQL Service account
Both servers can talk to each other - but so far setting up Log Shipping using the private IP addresses where appropriate fails.