Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

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

 
   Database Forums (Home) -> Clustering RSS
Next:  SAN settings for 3 SQL  
Author Message
Sas

External


Since: Oct 20, 2005
Posts: 4



(Msg. 1) Posted: Fri Oct 06, 2006 12:18 pm
Post subject: 2-node cluster (Active/Passive) but with a catch!
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

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."

 >> Stay informed about: 2-node cluster (Active/Passive) but with a catch! 
Back to top
Login to vote
Arnie Rowland

External


Since: Oct 18, 2004
Posts: 197



(Msg. 2) Posted: Fri Oct 06, 2006 12:29 pm
Post subject: Re: 2-node cluster (Active/Passive) but with a catch! [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" wrote in message

> 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."

 >> Stay informed about: 2-node cluster (Active/Passive) but with a catch! 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Slow Response on one node of an active/passive SQL Cluster - Problem with response time depending on which node of an active/passive cluster is active. If checked everything I can think of or Google suggested. What have I missed? Win2k3 SP1 SQL 2000 SP3a Hardware is the same on both nodes including memory...

2 Node Active/Passive - Failover when switch rebooted. - Hi Despite being directly connected with a crossover cable and each server being connected in to the switch, they seem to think that they need to failover when the switch goes off line. Why? Surely they should only be checking connectivity if the..

Rebuild SQL 2000 cluster to sql 2005 cluster active/passive - We have a EMC clarion SAN with fiber connection between 2 node cluster. Does anyone know how to rebuild/upgrade sql 2000 active/passive cluster to sql 2005 active/passive cluster in SAN. Do i have to kill the cluster and start from scratch? What's the....

Installing SQL Server 2005 64-bit on Active/Passive cluster - Hello! We will be installing SQL Server Enterprise Edition 64-bit on Windows 2003 64-bit Server. I was wondering if anyone could recommend step-by-step documentation on how to accomplish this task. Thanks, Igor

Configuring an SQL 2005 Cluster on a windows 2003 Active P.. - Hi All. I want to deploy an sql 2005 cluster on a Windows 2003 Active/Passive Cluster.Are there any KB articles avalible that will guide in deploying sql 2005 Cluster. Appreciate it. Regards -- Khalid
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]