| Author |
Topic |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2009-01-13 : 16:21:40
|
| Hi,I am going to upgrade sql server 2000 clustered to sql server 2005 clustered.It is Active/Passive environment.Can anyone please suggest a best approach to do this or share their experience. Thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 19:21:05
|
| Are new pairs of Server configured efficiently in terms of windows clustering Perspective? |
 |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-01-14 : 08:51:12
|
quote:
Originally posted by sodeep
Are new pairs of Server configured efficiently in terms of windows clustering Perspective?
Yes, right now in production active/passive cluster is working fine with out any issues. I want to know what is the best approach to upgrade sql server 2000 cluster to sql server 2005 cluster. I am hearing mixed reviews like it is easy and also if anything goes wrong it is tough.Please pass on any document which will be helpful in this upgrade.Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-01-14 : 14:21:30
|
| (1) reconfigure MSDTC into its own group(2) run the SQL 2005 setup on the active node(3) Install the SP3 on active node(4) Install SP3 on passive node (for client tools etc)Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-01-14 : 14:57:33
|
quote:
Originally posted by tkizer
There is no difference in the upgrade when it's on a cluster, regardless if it's active/passive or active/active. The upgrade is the same if it's on a cluster as it would be on a standalone system. Just find articles on 2000 to 2005 upgrades, we've got a few of them here at SQLTeam.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Thanks for confirming that it is similar to stand alone upgrade. When I looked online information out there really scared me.One question I know it's dumb , I think I can use same install CD I use when I upgrade standalone system, there is no separate installation CD for upgrading sql server on clustered environment.Thanks for your time |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-01-14 : 15:08:33
|
quote:
Originally posted by dinakar
(1) reconfigure MSDTC into its own group(2) run the SQL 2005 setup on the active node(3) Install the SP3 on active node(4) Install SP3 on passive node (for client tools etc)Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
Thanks Dinakar,can you please elaborate (1) reconfigure MSDTC into its own groupThe steps I am going to follow are:1.Do inplace upgrade 2.Apply sp3 to node1.Install sql server 2000 DTS designer component3.Bring Node1 offline , apply sp3 to node2 and Install sql server 2000 DTS designer component on node2.Please correct if there is anything wrong in my plan. Of course I have rollback plan if anything goes wrong. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-01-23 : 10:30:30
|
| Did inplace upgrade when running the Install it looked like it upgraded node2 also, while applying sp2 to Node1 , I got Failure status for Database Services Component, rest all componentswere ended successfully,when I googled for this I found out that it's a bug in SP2.BUG: The Installation Progress dialog box displays a status of Failure for the Database Services component when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 on an instance of SQL Server 2005Did anybody faced same problem.How did you resolve this?Thanks |
|
|
|
|
Clustered Upgrade