October 11, 2009 at 12:39 am
Hi,
We have a/a/p setup of SQL Server 2005 EE x64 with SP3 on Windoes 2003 EE R2 x64 with SP2.
Node1 has 2 instances
Node2 has 4 instances
Node3 is passive.
Now, We would like to Upgrade to SQL Server 2008. Here I have couple of questions:
1. Is this good time to Upgrade to SQL Server 2008?
2. Does people started using SQL Server 2008 in full fledged pace? or need to wait for 1 more year?
3. For our cluster environment mentioned above, which type of Upgrade method best suits In-Place OR Side-by-side Upgrade?
5. If I go for In-Place Upgrade, do I need to Upgrade first 2 instances on Node1 and then the 4 instances on Node2? What's the order of steps? Our servers are just 1 year old. So probably we may need to go for In-Place Upgrade!!
many thanks
October 11, 2009 at 7:54 am
Hi,
I can provide some input to 1 and 2
1. I think so- SQL 2008 is stable and reliable from my experience at SP1
2. We have gone live with a SQL Server 2008 SP1 server in Production (upgraded from SQL 2000). It was extremely straightforward and all the bugs we experienced were on the clients (mainly related to opening DTS).
October 12, 2009 at 12:45 pm
Could you please advice me..
October 12, 2009 at 10:11 pm
We have a/a/p setup of SQL Server 2005 EE x64 with SP3 on Windoes 2003 EE R2 x64 with SP2.
Node1 has 2 instances
Node2 has 4 instances
Node3 is passive.
We need to do In-Place Upgrade to SQL Server 2008. Could you please take me to some Microsoft learning course for this?? I did find this document "SQL2008UpgradeTechnicalReferenceGuide.docx" but it is not clear on particularly about in-place upgrade of Clustered instances
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply