Link to home
Start Free TrialLog in
Avatar of SYZH
SYZH

asked on

Sql server 2008 R2

     We currently have a SQL 2005 active/passive cluster We currently have a SQL 2005 active/passive cluster running on two physical boxes with Windows Server 2003. We'd like to upgrade to SQL 2008 R2 with Windows server  2008 R2 Any potential pitfalls we should be aware of, any precautions we might take ahead of time? We have the option of starting clean , but that has issues also as we will be using the same cluster names, and I'd overall prefer to upgrade the existing cluster if we aren't courting disaster. I would like to know the best possible steps to finish the task.Thanks.
Avatar of FarWest
FarWest

I think your OS now is windows 2003, right?
in my openion  the best way to do that and take your time for testing the new environmnet, is to build new cluster servers but as Hyper-V VM on any machine, after completeing the conversion if its is possible uninstall sql-server 2005 and upgrade the to windows 2008 R2 with hyper-v role, move the VM machines to them,
there are many helpful deployment scenarios that can take benifit of Hyper-V, just google it.
Avatar of SYZH

ASKER

But i do not want to work on H-v VM. I have two existing boxex DL580G6 4 Quad 2.93 GHz processors with 128 GB of RAM. I have already evicted the Passive node.
ASKER CERTIFIED SOLUTION
Avatar of FarWest
FarWest

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial