September 22, 2009 at 6:26 am
We are using SQL Server 2003 Enterprise Edition and have installed SQL Server 2005 on it. Now we are planning to move on with Windows server 2008. So i would like to know what are the steps that we should keep in mind for migration and what about the SQL server installed. if it is on the cluster then can we first upgrade the passive node then faliover and then upgrade the other node? and what if i have SQL Server installed on stand alone windows server 2003 environment? how do we do that. any idea is really appreciated.
September 22, 2009 at 6:42 am
any idea friends?
September 22, 2009 at 8:20 am
I am not sure I would like to have the production Servers Upgraded. I would rather have fresh install of the OS and install SQL Server 2005 (Why 2005? cant you go for 2008?) and fail over to that server.
Windows 2008 is a smart move since there is a big improvement in TCp/IP
-Roy
September 22, 2009 at 8:34 am
but do you think that i can failover to windows server 2008, because my active node will still be windows server 2003?
September 22, 2009 at 8:48 am
As per technet
"Migration scenarios in this guide
There are a variety of ways that you can use to perform the overall process of migration, and this guide describes two:
* Create a separate failover cluster running Windows Server 2008 and then migrate settings to it from a server cluster running Windows Server 2003. In this guide, the instructions for creating the separate failover cluster tell how to create a two-node failover cluster, but additional nodes could be added to the failover cluster.
* Perform an in-place migration involving only two servers. In this scenario, you start with a two-node server cluster that is running Windows Server 2003, remove a server from the cluster, and install Windows Server 2008 on that server. Next, you use that server to create a one-node failover cluster, and migrate the settings from the old server cluster node to that failover cluster. Finally, on the old server cluster node, you install Windows Server 2008 and the failover cluster feature, add the server to the failover cluster, run validation tests to confirm that the overall configuration works, and then bring the migrated resources online."
Check for more details here...
-Roy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply