 | |
MIGRATING SQL CLUSTER SERVER
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
MIGRATING SQL CLUSTER SERVER -
05-11-2005
, 06:58 AM
#2
| |||
| |||
|
|
Hi everyone We have 2 cluster servers and each server has 3 instances (under WINDOWS 2003), all these is under a domain IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA3 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB3 We want o to migrate these instances to another 2 new servers which also will be clustered, but first we have to do some tests restoring the data etc. . Since we have to many people that connects to these server using ODBCS that have been setup and also they had created programs that includes the server name as a hard code would like to keep the same instances names and also give the same server name to the new ones. The plan is to shutdown the old servers once the new server have been finally restore. The question here is: Under the same domain, while the current cluster servers are running, can we setup the new servers with those servers names and also create the same instances as they are? Current Server New servers IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA3 IDBPA\IDBPINSTA3 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB3 IDBPB\IDBPINSTB3 Actually I don't think is possible but my boss is asking me to try to see if we can do this. What I proposed was to make a backup of the databases, shutdown the current servers, setup the new servers with the names and instances as the current cluster servers (IDBPB,ext ) and restore the databases with our disaster recovery exercise in order to the do the migration. Start the services in the new servers and everybody will be happy and connect to the new servers. The old server will have to be redo because these are going to be our testing servers. But as i said, that was my proposal, but returning to the question, can we have 2 cluster servers under a domain and create another 2 new ones with the same server name and instances? Will the ODBC'S will know where to connect? What is the best solution in order to migrate a SQL SERVER CLUSTERS? Thanks |
#3
| |||
| |||
|
|
Hi Only 1 server can have the same name on a network at a time. You can change the domain that a cluster belongs to, but no the cluster name. You need to use a different name and have all your applications re-pointed at the new cluster name. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike (AT) epprecht (DOT) net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "Carolina Garcia" <Carolina Garcia @discussions.microsoft.com> wrote in message news:47C56F18-7DF8-43BC-8D7C-984850DBBEE4 (AT) microsoft (DOT) com... Hi everyone We have 2 cluster servers and each server has 3 instances (under WINDOWS 2003), all these is under a domain IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA3 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB3 We want o to migrate these instances to another 2 new servers which also will be clustered, but first we have to do some tests restoring the data etc. . Since we have to many people that connects to these server using ODBCS that have been setup and also they had created programs that includes the server name as a hard code would like to keep the same instances names and also give the same server name to the new ones. The plan is to shutdown the old servers once the new server have been finally restore. The question here is: Under the same domain, while the current cluster servers are running, can we setup the new servers with those servers names and also create the same instances as they are? Current Server New servers IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA3 IDBPA\IDBPINSTA3 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB3 IDBPB\IDBPINSTB3 Actually I don't think is possible but my boss is asking me to try to see if we can do this. What I proposed was to make a backup of the databases, shutdown the current servers, setup the new servers with the names and instances as the current cluster servers (IDBPB,ext ) and restore the databases with our disaster recovery exercise in order to the do the migration. Start the services in the new servers and everybody will be happy and connect to the new servers. The old server will have to be redo because these are going to be our testing servers. But as i said, that was my proposal, but returning to the question, can we have 2 cluster servers under a domain and create another 2 new ones with the same server name and instances? Will the ODBC'S will know where to connect? What is the best solution in order to migrate a SQL SERVER CLUSTERS? Thanks |
#4
| |||
| |||
|
|
Mike is right, there's no way to name the machines the same, but you could trick it with DNS. Create the new servers with the new names you want and then when you're ready to do a test, take the old machines down and create a DNS alias pointing traffic from the old names to the new server IP's. Should work. "Mike Epprecht (SQL MVP)" wrote: Hi Only 1 server can have the same name on a network at a time. You can change the domain that a cluster belongs to, but no the cluster name. You need to use a different name and have all your applications re-pointed at the new cluster name. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike (AT) epprecht (DOT) net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "Carolina Garcia" <Carolina Garcia @discussions.microsoft.com> wrote in message news:47C56F18-7DF8-43BC-8D7C-984850DBBEE4 (AT) microsoft (DOT) com... Hi everyone We have 2 cluster servers and each server has 3 instances (under WINDOWS 2003), all these is under a domain IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA3 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB3 We want o to migrate these instances to another 2 new servers which also will be clustered, but first we have to do some tests restoring the data etc. . Since we have to many people that connects to these server using ODBCS that have been setup and also they had created programs that includes the server name as a hard code would like to keep the same instances names and also give the same server name to the new ones. The plan is to shutdown the old servers once the new server have been finally restore. The question here is: Under the same domain, while the current cluster servers are running, can we setup the new servers with those servers names and also create the same instances as they are? Current Server New servers IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA3 IDBPA\IDBPINSTA3 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB3 IDBPB\IDBPINSTB3 Actually I don't think is possible but my boss is asking me to try to see if we can do this. What I proposed was to make a backup of the databases, shutdown the current servers, setup the new servers with the names and instances as the current cluster servers (IDBPB,ext ) and restore the databases with our disaster recovery exercise in order to the do the migration. Start the services in the new servers and everybody will be happy and connect to the new servers. The old server will have to be redo because these are going to be our testing servers. But as i said, that was my proposal, but returning to the question, can we have 2 cluster servers under a domain and create another 2 new ones with the same server name and instances? Will the ODBC'S will know where to connect? What is the best solution in order to migrate a SQL SERVER CLUSTERS? Thanks |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.