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 |
|
manxen
Starting Member
2 Posts |
 Posted - 2009-04-17 : 05:40:12
|
| HI All,This is very complex situation, We have a SQL Server 2000 Cluster(Active/Active), 1 node is Development another is Production. We have to upgrade this SQL 2008. being Dev & Prod node. we cannot upgrade at same time, client asked us to upgrade Dev Node later they will go with Production node.How to proceed on this. please help.ThanksManish@9986501941 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-17 : 12:05:47
|
| thats a crazy setup you have.. who ever made that genius of a decision.. if some developer installs some SP on the DEV instance and reboots the nodes your prod server can go down or lose failover capability. you can upgrade the prod instance to 2008 leaving toe DEV on 2000. just run the setup on both nodes and make sure you choose the right instance. it should be fairly straight forward.. SP1 is out btw so you might want to install that too.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Active Active 2000 upgrade to 2008