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

Windows Cluster Servers Migration Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 3:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 26, 2014 11:10 PM
Points: 26, Visits: 160
Dear Friends,

I need valuable suggestion to do the Servers Migration and SAN relocation in the below scenario:

SQL Server Setup in Windows Clustering: We are currently running with 3 physical Servers and hosted with 2 Node Cluster. I mean Server 1 is active for one Instance (Default Instance), Server 3 is active for another instance (Named instance) and Server 2 is passive for both the instances. All the system and user data files are hosted in SAN Drives. And also we have transactional replication configured for User databases from Server 1 & Server 3 to one more Standalone Server called XXXX. Due to performance issues with Servers and Storage we are planning to replace the old Servers with new Servers as well SAN Box.

As part of this Process we have 2 Physical Servers in place for replacement of Server 1, Server 3 & 1 Server will be taken from existing i.e. Server 3.

Now we are looking to build the setup with without changing any Static and Virtual IP’s. Can you please suggest the suitable solution to implement this PLZ?

1.We can build the new Server and the same can be added to cluster Group by removing of passive one (Server 2). After that we can failover from Server 1 to Server 2, I hope it will work, because all the installation was happened to SAN Disks. But when we are planning to migrate the SAN, can we able to move the System databases from one location to another location without any interruption?
2. After adding the Server in to Cluster Group, does it required SQL Installation again or failover will take care of it?
3.Normally whenever there was a change in System databases, and then we need to reinitiate the Replication process freshly. I hope we can also initiate the replication from Backup when we are doing the changes in same Server / instance within in the system databases.
4.It would better to have fresh Cluster setup with 2 new Servers with different IP’s. So that we can easily move the Data files and configure the Replication. But it’s going to be a time consuming process to configure the entire Replication and change in IP’s will cause the configuration changes. So application team expecting no changes in IP’s.

Please suggest the suitable solution to do this. Thanks in advance.

Regards, Thulasi.
Post #1382374
Posted Friday, November 9, 2012 5:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 6,178, Visits: 13,323
trayalacheruvu (11/8/2012)
[font="Verdant"]Dear Friends,

I need valuable suggestion to do the Servers Migration and SAN relocation in the below scenario:

SQL Server Setup in Windows Clustering: We are currently running with 3 physical Servers and hosted with 2 Node Cluster. I mean Server 1 is active for one Instance (Default Instance), Server 3 is active for another instance (Named instance) and Server 2 is passive for both the instances. All the system and user data files are hosted in SAN Drives. And also we have transactional replication configured for User databases from Server 1 & Server 3 to one more Standalone Server called XXXX. Due to performance issues with Servers and Storage we are planning to replace the old Servers with new Servers as well SAN Box.

You would be better off migrating to a new cluster.


trayalacheruvu (11/8/2012)
Now we are looking to build the setup with without changing any Static and Virtual IP’s. Can you please suggest the suitable solution to implement this PLZ?

Without taking the original equipment down it will be difficult as the IP and network names will already be claimed by the running services.


trayalacheruvu (11/8/2012)
1.We can build the new Server and the same can be added to cluster Group by removing of passive one (Server 2). After that we can failover from Server 1 to Server 2, I hope it will work, because all the installation was happened to SAN Disks. But when we are planning to migrate the SAN, can we able to move the System databases from one location to another location without any interruption?

What operationg system do the current and new machines use?

It may be possible to join the new server to the existing cluster and then do an in place upgrade on the instance. Its also possible to mirror the LUNs, but i think you're opening a can of worms here. I still recommend you perform a clean migration.


trayalacheruvu (11/8/2012)
2. After adding the Server in to Cluster Group, does it required SQL Installation again or failover will take care of it?

Yes any new node needs to have the SQL server software installed for the instance it is joining.


trayalacheruvu (11/8/2012)
3.Normally whenever there was a change in System databases, and then we need to reinitiate the Replication process freshly. I hope we can also initiate the replication from Backup when we are doing the changes in same Server / instance within in the system databases.

What do you mean here


trayalacheruvu (11/8/2012)
4.It would better to have fresh Cluster setup with 2 new Servers with different IP’s. So that we can easily move the Data files and configure the Replication. But it’s going to be a time consuming process to configure the entire Replication and change in IP’s will cause the configuration changes. So application team expecting no changes in IP’s.

I guarantee you, you are creating more work and potential problems by pursuing the route you are looking at.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1382983
Posted Wednesday, November 14, 2012 5:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 26, 2014 11:10 PM
Points: 26, Visits: 160
Hi Thanks for the reply.

1. What operating system do the current and new machines use?

Windows 2003 Server.

2. Yes any new node needs to have the SQL server software installed for the instance it is joining.

Yes , when we are doing SQL Install in stand alone Server it won't promote for Failover Option. we can do this only when we are logged in through VIP. But here we have Active Server running for Prod from Cluster Group , so we need to make the passive Server ready offline and need to failover from Active to passive. In this case if we install SQL in stand alone in different drives does this work to failover from Active to passive? consider that our Active server SQL was installed in Old SAN Disks and New Server can be connected to both SAN Disks.

3. Normally whenever there was a change in System databases, and then we need to re-initiate the Replication process freshly. I hope we can also initiate the replication from Backup when we are doing the changes in same Server / instance within in the system databases.

I mean , can we able to preserve the replication settings through backup file in different servers?

Regards,
Thulasi..
Post #1384547
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse