August 9, 2011 at 1:13 pm
SO we are in the process of upgrading our SQL servers clusters to SQL 2008 R2 clsuters. We are using the existing hardware so i guess we will do an inplace upgrade. Not sure how to do it so if anyone can help with the steps required to successfully do this.
Here are the specs now to then.
Now:
SQL server 2005 Standard
Cluster (active/passive)
win server 2003
Then
SQL server 2008 R2 Enterprise
Cluster (active/passive) existing hardware as above.
win server 2003
August 10, 2011 at 5:45 am
I'd suggest you don't, experience has shown that inplace upgrades are good in certain circumstances but not for production systems.
I'd suggest you evict a node, rebuild it, migrate your databases, drop that node, rebuild it and add back into the cluster.
Personally I'd be surprised if you could do an upgrade in place as clustering is just so different in windows 2008, as you'll no doubt discover!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 10, 2011 at 5:49 am
oops - sorry keeping o/s the same? I'm not 100% sure if you can install sql 2008 R2 on windows 2003, and why would you want to keep an o/s going out of support?
SQL 2008 R2 is designed to run on windows 2008 R2.
I still wouldn't upgrade a sql server in place either, did it once - very bad idea.
Last time I did such an upgrade we rebuilt the cluster too - there's just too much stuff which gets left behind.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 11, 2011 at 5:58 pm
Colin thanks for answering my question.
So we are not doing an inplace upgrade. Instead going to decluster, rebuild the node to win serv 2008 and SQL 2008 R2 and then reattach the DBs. Will this work?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply