Newbie Question

I inherited a 2000 Advanced Server SQL 2000 Ent, Active-Passive setup. The
architect never got it working correctly, so he turned off the second node
and just left it running of the primary. We've been having reporting errors
in our application so I checked to see if everything was up-to-date and the
SQL Installation was still at the RTM level, no SPs at all (no wonder he had
problems). Because it's the end of the year and we needed to fix the problem
ASAP I evicted the second node and ran SP3a on the primary node to get our
reports on time.
Now what I'd like to do is set the thing up correctly, but am unsure of how
to approach bringing the evicted node back online as a failover node and get
it up to SP3a.
I'd be happy to hire an expert for a few hours if one of you MVPs lives in
Southern California, or wants to do a conference call and thinks that my
situation is too messed up to fix via newsgroup. If there is a good book I
can read on SQL clustering I'd like to hear about that as well.
Thanks.
Patrick Rouse
Microsoft MVP - Terminal Server
http://www.workthin.com
I think I may have found my answer here?
http://www.microsoft.com/windowsserv...5-d622b5b61369
&mid=8665605b-5a16-452f-8183-02b06b312b7f
"Patrick Rouse" wrote:

> I inherited a 2000 Advanced Server SQL 2000 Ent, Active-Passive setup. The
> architect never got it working correctly, so he turned off the second node
> and just left it running of the primary. We've been having reporting errors
> in our application so I checked to see if everything was up-to-date and the
> SQL Installation was still at the RTM level, no SPs at all (no wonder he had
> problems). Because it's the end of the year and we needed to fix the problem
> ASAP I evicted the second node and ran SP3a on the primary node to get our
> reports on time.
> Now what I'd like to do is set the thing up correctly, but am unsure of how
> to approach bringing the evicted node back online as a failover node and get
> it up to SP3a.
> I'd be happy to hire an expert for a few hours if one of you MVPs lives in
> Southern California, or wants to do a conference call and thinks that my
> situation is too messed up to fix via newsgroup. If there is a good book I
> can read on SQL clustering I'd like to hear about that as well.
> Thanks.
> --
> Patrick Rouse
> Microsoft MVP - Terminal Server
> http://www.workthin.com
|||Yep.. That is the correct procedure. See 'Maintaining a Failover Cluster'
in BOL for a detailed version. Pretend your second node has failed
completely.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Patrick Rouse" <PatrickRouse@.discussions.microsoft.com> wrote in message
news:12DFE27E-534D-4B31-94B3-03E15EFD3AA9@.microsoft.com...
> I think I may have found my answer here?
>
http://www.microsoft.com/windowsserv...5-d622b5b61369
&mid=8665605b-5a16-452f-8183-02b06b312b7f[vbcol=seagreen]
>
> "Patrick Rouse" wrote:
The[vbcol=seagreen]
node[vbcol=seagreen]
errors[vbcol=seagreen]
the[vbcol=seagreen]
had[vbcol=seagreen]
problem[vbcol=seagreen]
our[vbcol=seagreen]
how[vbcol=seagreen]
get[vbcol=seagreen]
in[vbcol=seagreen]
book I[vbcol=seagreen]

Newbie MSDTC question

What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster?
Cluster is already setup and virtual sql instance running ok...
Thanks
MSDTC or the Microsoft Distributed Transaction Cordinator is used for
distributed transactions.
A good description of it can be found in SQL Server Books Online:
http://msdn.microsoft.com/library/de...ar_cs_321x.asp
As you can see in the following article; MS DTC is not required for the
clustered SQL Server to work:
http://support.microsoft.com/default...b;en-us;260758
However if you have it installed on your server you need to run it in a
clustered state as you can see in the following article:
http://support.microsoft.com/default...b;en-us;301600
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Lapchien" <ccarswell@.nospameclipse.co.uk> wrote in message
news:11273pop2eunj40@.news.supernews.com...
> What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K
> cluster? Cluster is already setup and virtual sql instance running ok...
> Thanks
>
>
|||While we are on the subject of MSDTC within a SQL Cluster, Simon has
referred to the standard (in my mind superficial) documentation on MSDTC, I
am looking for more detailed information:
1. The detailed architecture and how a transaction enlists target
databases.
2. How the authentication and permissions work for MSDTC in detail
(e.g.. why Cluster permissions are required for services enlisting MSDTC in
a cluster).
I have configured several high-availability applications requiring
distributed transactions and fully understand the requirements for
successfully implementing MSDTC/SQL, however I would like to understand the
internal operations of MSDTC.
Regard
Gary Hope
"Simon Lidberg [MSFT]" <simonlid@.online.microsoft.com> wrote in message
news:eHmSQLeHFHA.896@.TK2MSFTNGP10.phx.gbl...
> MSDTC or the Microsoft Distributed Transaction Cordinator is used for
> distributed transactions.
> A good description of it can be found in SQL Server Books Online:
> http://msdn.microsoft.com/library/de...ar_cs_321x.asp
> As you can see in the following article; MS DTC is not required for the
> clustered SQL Server to work:
> http://support.microsoft.com/default...b;en-us;260758
> However if you have it installed on your server you need to run it in a
> clustered state as you can see in the following article:
> http://support.microsoft.com/default...b;en-us;301600
> Simon
> This posting is provided "as is" with no warranties and confers no rights.
> "Lapchien" <ccarswell@.nospameclipse.co.uk> wrote in message
> news:11273pop2eunj40@.news.supernews.com...
>