Move Databases

Toemsn erstellt 2 Mai 2012 08:47

Hello,

we have a SQL-Cluster 2008 R2 containing "Server1" and "Server2". The Cluster Name is "SQLLive". All servers are VMs. On this cluster we put all our Sharepoint 2010 Databases an Some Databases for our ERP-Software. We didn't made an SQL-Alias Entry at the Sharepoint Server. So the "SQLLive" instance is direct configured in the Central Administration.

Now we have to split up these databases on several instances due to performance issues. Also the Cluster we want to break up. But for both (Sharepoint and the ERP-System) it would be great to keep the SQL-Server-Name or alias.

So my Idea would be. Removing the second cluster node. I'm not sure if the remaing virtual SQL-Instance has still the name "SQLLive" or "Server1"? Than i want to rename the SQL-Instance to "Server1" and leave all the Sharepoint databases on it. Than Installing another Server (physical) with SQL 2008 R2 with Name "SQLLive" and put all the ERP Databases to this instance. So for my ERP-System nothing changes. But for the Sharepoint Server the database name now is "Server1" and not "SQLLive". That issue i wanted to fix with an SQL-Alias at the Sharepoint Server with the Name "SQLLive", pointing to "Server1".

Is that a way to go? Do you have other ideas?

Thanks,

Thomas