Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to create DR SQL server Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 11:00 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:44 AM
Points: 701, Visits: 1,731
Hi,

We have SERVER A that is here locally. It is a 2008R2 box on Windows 2008R2 Enterprise.

We need to have an exact mirror of Server A in our remote DR location.

Server A is using VMware 5.1.

Technically I can restore to our DR site a cloned image of server A, but server A must have the same server name - which is a problem on the same network.

What's the best method to have Server A database A be a high availability DR server to our remote location server?

There is only one DB that I need to keep in sync. But again the problem is that the remote server needs to be a mirror of server A with the same ip, same server name.




Post #1498494
Posted Saturday, September 28, 2013 12:55 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 5,974, Visits: 12,875
I am no VMware expert and may have the terminology wrong but you can definitely vmotion(?) or bring up a virtual server in another location with the same ip address, name, everything if the original goes down.

As its a virtual server this is definitely the way to go to achieve your objectives. Both servers are never up at the same time so no network problems. speak to your sysadmins.


---------------------------------------------------------------------

Post #1499711
Posted Sunday, September 29, 2013 8:57 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:12 PM
Points: 4,386, Visits: 9,502
The only way to have two servers up and available with the same name is to have 2 domains. The production domain and the DR domain.

In order for that to work, you also have to make sure the domains are fully trusted so any authentication done on prod domain will be trusted on the DR domain.

There is value to having multiple domains - where you can then have a dev/test domain, prod domain, DR domain, etc... This allows for segmenting the servers and can isolate things very nicely. However, in order to be able to do something like this you have to have a networking and AD team that really understand the setup and can manage it.

With that said, it is not necessary to do that to bring up a cloned server. During the cloning process - when the new server is being built your server team can rename the server, setup a new IP address, etc...

This will break SQL Server, but that is easy to fix with a simple drop server and add server.

Note: since this is going to your DR site, you probably cannot do a straight clone. You probably have to export the image and import the image onto the VM farm in your DR site. This requires a server downtime - your server team will need to take the server offline.

Either way - you will need SQL Server down to perform the clone or you may well find that the database files are corrupted and unusable.

So, as a DR strategy this doesn't work - for DR you will need to look at mirroring, log shipping or SAN replication as options. But, you can do any of these once you have a server setup in your DR site.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #1499752
Posted Monday, October 7, 2013 6:46 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:44 AM
Points: 701, Visits: 1,731
Thanks Guys.

Jeffery we are going the two domain route.



Post #1502109
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse