Re: Using sql server failover clustering

Tech-Archive recommends: Fix windows errors by optimizing your registry

Whell Hilary:

I convince my boss to work on sql server failover clustering for better high
avilability and performance.

For what i've seen is: and here are my questions
1. I need to create windows clustering between the nodes as windows failover
clustering and not NLB clustering. Is it true?
2. I need sql server 2005 enterprise edition on both servers?
3. Does the data which entered to the database on main node is being
transfered by MS-DTC to passive nodes?
4. After the main server has revived, how does it return to be primary?

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OASsnUd0HHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
I am not sure what a shered database is. Perhaps you mean a shared
database. The databases and other resources are shared between nodes in a
cluster. At one time the primary node will "own" all the clustered
resources, and the secondary node (the inactive node) will own none. When
you failover the roles will be reversed and the former secondary/inactive
node will become the primary active node and now own all the resources.



--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:%23lMTC8a0HHA.4652@xxxxxxxxxxxxxxxxxxxxxxx
Hello there

For my knowlage to implement sql server failover clustering i need at
least 2 servers: one as primary node. and second as secondery node

But in all diagrams i've seen Shered database. What is it? another
server?





.

Relevant Pages

  • Re: Indexes Confuses me!!
    ... Kalen Delaney has a column called Inside SQL Server in SQLMag ... and performs a bookmark lookup. ... reading the actual data row costs a single logical page read. ... >>>>>performing a bookmark lookup using clustering keys (i.e., ...
    (microsoft.public.sqlserver.programming)
  • Re: Using sql server failover clustering
    ... I convince my boss to work on sql server failover clustering for better high ... and the secondary node will own none. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Quorum Disk or Majority Node?
    ... SQL Server does not NATIVELY support MNS clustering. ... >> The chapter "Three-Site Majority Node Set Quorum in Geographically ...
    (microsoft.public.sqlserver.clustering)
  • RE: Clustering Set up
    ... Both SQL Server 2000 Failover Clustering and SQL Server 2000 Log Shipping are disaster recovery options. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using sql server failover clustering
    ... This says that NODE1 has a local disk and NODE2 has a local disk. ... For a clustered instance of SQL Server, ... I convince my boss to work on sql server failover clustering for better ... My database size is more then 20Gb and in some cases more then 100Gb. ...
    (microsoft.public.sqlserver.clustering)