Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paul_dilip
Starting Member
1 Post |
 Posted - 2010-01-17 : 05:28:35
|
| We are using Sql Server 2008 Enterprise x64 edition on Windows Server 2003 Ent platform. The production environment is configured in a 2 node Active/Passive cluster. Our requirement is to setup a remote DR site using SRDF R1-R2 SAN (EMC) based replication. This is the standard DR model followed for Oracle & Unix and we have instructed to do a PoC for the same model using Sql & Windows cluster. The remote site already has a setup similar to production (Sql 2008 Ent x64 + 2 node cluster) and is currently used as a Staging Environment. The apps team wants the remote DR site to have the same name as the production instance. So achieve all this I plan to do the following:1. The replication will happen between the shared disk resouces (which Sql Server uses in Production) to the DR SAN.2. I will bring down the production instance and delete the Sql Server Network Name in DNS3. The DR SAN will be made available in the DR site.4. The sql Server related folders (instance root directory say MSSQL10.InstanceID) will be renamed5. I will install a 2nd intance in the DR site with the same name, disk configuration and patch levels as in production.6. Then bring down the sql server services in DR.7. Rename the Sql Server folders (of the newly installed instance) to a dummy name.8. Rename back the folders (modified in Step 3) to the actual names9. Bring up the Sql Server services.10. I believe the Sql Server will be automatically mapped to the production data.11. By keeping the DR Instance with the same name as production I hope to avoid any registry errors or any other dll missing issues.The entire method is kind of complex. I want to take this up as a PoC and check if it works. Please advise if I'm going to run into any problems . |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Sql Cluster instance 2008 with same virtual name a