Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Background Info

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.

share|improve this question
    
You use sysprep in C:\Windows\System32\sysprep to reset the internal id's so the clones are different. Select Enter System Out-of-Box Experience and the Generalize checkbox. –  MartinC Jan 5 '12 at 18:55
    
That is true but the sql machines are on different domains so there shouldn't afaik ever be a conflict of SIDs. I have done a sysprep in the lab anyway to see what different it makes if any. –  David Christiansen Jan 6 '12 at 9:37
    
I'm going to try setting hostnames such as 'Server1-Private' in the hosts file (pointing to the private IPs I referred to earlier) –  David Christiansen Jan 6 '12 at 9:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.