Cluster under sqlserver 2000

I would like to know if the clustering under sqlserver 2000 works fine.
Could you give some pointers in order to install a cluster under sqlserver ?
Best regardsorion30,
Yes SQL Server has fault tolerance capabilities which can be implemented with
the help of its clustering feature. SQL Server has two types of cluster
configuration ie Active/Active and Active/Passive cluster.
A cluster is a safeguard for fault tolerance for the servers, the operating
system, and the software. You can safeguard the data with the help of shared
disk arrays.
MS has a clustering feature to its operating system in Windows NT 4.0 Enterprise
Edition / WIN2K advanced & datacenter servers, this clustering feature is called
MSCS ie Microsoft Clustering Server. SQL Server's enterprise edition ships with
Clustering feature(Virtual Server).
For more information on cluster visit this url
http://www.sql-server-performance.com/clustering_intro1.asp
Also you can post your queries to more relevent newgroup
microsoft.public.sqlserver.clustering
-- Vishal
"orion30" <orion30@.ifrance.com> wrote in message
news:bri7f1$bvi$1@.news-reader5.wanadoo.fr...
> I would like to know if the clustering under sqlserver 2000 works fine.
> Could you give some pointers in order to install a cluster under sqlserver ?
> Best regards
>

Cluster installation

Hi guys,
Tks a million for your prompt reply. I have another question to ask u guys.
What are the order of installing server and sql clustering?
Is it W2k3sp1,MSCS,MSDTC,SQL,SQLsp3?
Tks once again for your help.
Message posted via http://www.droptable.com
You got it right. the only other thing I'd add is the SQL hotfix after
applying SQL SP3a:
http://support.microsoft.com/default...b;en-us;821277
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Mohd Hidayat via droptable.com" <forum@.droptable.com> wrote in message
news:958ee67996bc41df83c74e63f49157d4@.droptable.co m...
Hi guys,
Tks a million for your prompt reply. I have another question to ask u guys.
What are the order of installing server and sql clustering?
Is it W2k3sp1,MSCS,MSDTC,SQL,SQLsp3?
Tks once again for your help.
Message posted via http://www.droptable.com

Cluster index on 2 columns order

I have 2 columns in a table namely ColA and ColB.all DML operations are through views n every view has

Where clause i.e where ColA=”” with check option .

All most all my DML queries are using where clause on ColB

Where ColB=””

Now my question is I have a clusted index on both ColA and ColB.in which order I have to create cluster index .

i.e ColA ASC,ColB ASC or ColB ASC,ColA ASC.

Is there any performance gain we can achieve with their order

The only way to find out for sure is to try it both ways. It also depends on which queries or SP's are run most frequently.

Generally speaking, you want the most selective column to be first in the clustered index.

I would turn on SET STATISTICS IO ON, and turn on your Graphical Execution plan, and then run some of your most frequently executed queries and see which version of the clustered index gives you the best results.

cloneing?

I have a merge replication that is really fouled up. I need to get things
back in order. Right now I have three offices working on the database
locally(no replication going on) At the end of the day I want to get all of
the new data back to the publisher so we can create a new snapshot. I was
told by the software vendor of the interface of the database to clone
without hostnames or supporting records. I am kinda at a loss as to what
that means. I see that I can export the data to another server and choose to
append the data, is that what he meant? Any help would be very much
appreciated.
Curt
I suggest you contact the vendor and ask him exactly what he means. Say you
did a search on BOL one clone, cloning and supporting records and came up
with no results.
If you do a reinitialization you will be prompted to upload the changes from
the subscribers before reinitializing. Perhaps this is what the vendor
meant.
I suggest before you even do this you go through the conflicts table(s)
using the conflict viewer and resolve any conflicts.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Curt Shaffer" <curt@.chilitech.net> wrote in message
news:ch4k8c01hif@.enews3.newsguy.com...
> I have a merge replication that is really fouled up. I need to get things
> back in order. Right now I have three offices working on the database
> locally(no replication going on) At the end of the day I want to get all
of
> the new data back to the publisher so we can create a new snapshot. I was
> told by the software vendor of the interface of the database to clone
> without hostnames or supporting records. I am kinda at a loss as to what
> that means. I see that I can export the data to another server and choose
to
> append the data, is that what he meant? Any help would be very much
> appreciated.
> Curt
>