Re: Cluster Set up Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The SQL Installer is cluster-aware. That is, it handles all the details of
cluster-wide installation. It creates the virtual server and installs the
local binaries on all nodes. It also groups all the cluster resources and
sets the dependencies correctly. Once SQL is running and you are connected,
there is almost no difference in SQL operations between clustered and
non-clustered SQL Servers. You end up connecting to a virtual SQL Server
instance that looks identical regardless of which node is actually hosting
it at the moment.

Here is an excellent overview of SQL failover clustering that you may find
helpful:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"mvp" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95A55E02-1BCB-47E1-9458-E01080486B3D@xxxxxxxxxxxxxxxx
> Thanks Geoff.
> So From your reply, I understand that i will have to install SQL SERVER
> 2000
> on both the windows 2003 server.
>
> I have following questions.
>
> 1) After installing SQL SERVER on both the windows m/c, When i create
> database on both the machine, Would i have to mentioned same Data files
> and
> Transaction Log Path ( Because we will have storage will be in SAN), when
> i
> create DB ?
> 2) For example if i create one table in the FinDB of on ServerA and then
> if
> i go to FinDB of ServerB, I will see that table there too, if i will have
> Datafiles and Transaction Log Path are same for both the servers ?
>
> "Geoff N. Hiten" wrote:
>
>> A cluster consists of two machines and a storage system that is
>> physically
>> connected to both systems. The Cluster software arbitrates ownership of
>> the
>> disk resource so that only one server can access it at a time. The
>> cluster
>> software also monitor the sql instance on the active host node for
>> failure.
>> If the first node fails, ownership of the SQL instance and the
>> corresponding
>> disk resource is transferred to the other node. From the outside, it
>> looks
>> like the SQL Server stopped and restarted.
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "mvp" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@xxxxxxxxxxxxxxxx
>> > Hello,
>> > We are implementing clustering (Active/Passive) in our Production
>> > environment.
>> > So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1
>> > and
>> > ProdDbServer2)
>> > I will install SQL Server on both the machine and i will create my
>> > database
>> > (FinDB)
>> > on both the machine's SQL SERVER with all the tables,store procs,
>> > functions
>> > etc.
>> >
>> > So lets say if my Active Server is in action and accepting all the OLTP
>> > transaction
>> > and for some reason if it goes fail...How can passive server can take
>> > over,
>> > how
>> > passive server can be at the same point of the fail of active server ?
>> >
>> > Bacically how both the Database will be in sink with each other ?
>> >
>> > Pls help me
>>
>>
>>


.

Relevant Pages

  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Cant get SQL 2000 installed on new node in Cluster
    ... You can apply a service pack to a new node without taking the Virtual SQL ... server offline. ... When the install is asking for a virtual server name, ... one for the MSCS cluster or the one for the SQL cluster? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Exchange 2007 CCR on Windows 2008 x64 RTM
    ... install guide, but I always did it too quickly after the failure. ... I'm an MCITP on Server 2008 & Exchange ... I'm told that this is caused by the way the cluster service creates the ... respond to the start or control request in a timely fashion occured ...
    (microsoft.public.exchange.setup)
  • Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... SQL Server 2000 EE ... I had a three-node A/A/P cluster. ... Install SQL 2000 binaries on newly added node for Instance 1 ... "All cluster disks available to this virtual server are owned by other nodes." ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)