Monday, March 19, 2012

2-node cluster (Active/Passive) but with a catch!

Hi,
We have 2 blade servers and we need a clustering solution which will run
win2k3 and SQL 2005 in an Active/Passive mode. The catch is that our SAN will
not be in for another 5 weeks. The business needs to go live so I am trying
to find out what is the best way to handle this. I am thinking the following:
Install sql server 2005 on one server and run it as a stand alone until we
get the SAN. Then configure the second with the SAN and MSCS, migrate the
databases, rebuild the first server, install MSCS and join it to the cluster.
What do you guys think?
--
Senior DBA
MSc in CS, MCSE4, ITIL, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."
It seems like you have a grip on the problem/solution.
Without some form of common storage resources, I don't see that you have
much of a choice.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Sas" <Sas@.discussions.microsoft.com> wrote in message
news:7206318F-DC16-4C51-9D7A-DD59C441D863@.microsoft.com...
> Hi,
> We have 2 blade servers and we need a clustering solution which will run
> win2k3 and SQL 2005 in an Active/Passive mode. The catch is that our SAN
> will
> not be in for another 5 weeks. The business needs to go live so I am
> trying
> to find out what is the best way to handle this. I am thinking the
> following:
> Install sql server 2005 on one server and run it as a stand alone until we
> get the SAN. Then configure the second with the SAN and MSCS, migrate the
> databases, rebuild the first server, install MSCS and join it to the
> cluster.
> What do you guys think?
> --
> --
> Senior DBA
> MSc in CS, MCSE4, ITIL, IBM Certified MQ 5.3 Administrator
> "I saw it work in a cartoon once so I am pretty sure I can do it."

No comments:

Post a Comment