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 |
|
SQLBuddy123
Starting Member
26 Posts |
 Posted - 2009-06-23 : 14:58:23
|
| Hi, I have a SQL Server 2005 instance on a 2-node Active/Active cluster. To migrate that instance on to a new physical server, we are actually stopping the SQL Server service on the old server and copying all the data and log files on to the new server and attaching them to the new server.But if we stop the SQL server service on node1, the instance will be failed over to the node2. Then we can’t copy the data and log files because the instance is now running on the node2. So should I set the SQL Server service “Start Mode” on the node2 to be Manual and then stop the SQL Server service on the node1 so that SQL Server will not be failed over to the node2 and then copy the files on to the new server? Am I correct?Could anyone help me with this? Thank You,Yours,SQLBuddy |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-23 : 15:16:29
|
| You can just take the resources offline and move your data....just make sure you are offlining the correct instance resources.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
SQLBuddy123
Starting Member
26 Posts |
Posted - 2009-06-23 : 16:24:21
|
| Hi Dinakar, Thank you very much for your reply. But, when you say that take the resources offline, you mean we should take the Resource group of that instance under the Groups node in the cluster administrator offline?Yours SQL Buddy |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-24 : 09:50:19
|
| yes.. under the resource group you can offline individual resources... so you could take off sql server and sql agent.. and start your data transfer..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
SQLBuddy123
Starting Member
26 Posts |
Posted - 2009-06-24 : 11:44:57
|
| Hi Dinakar, Thank you very much for your reply. I really appreciate your help.YoursSQLBuddy |
|
|
|
|
|
|
Cluster Instance