Database Clustering in MS SQL SERVER.

Hi,
I want to do database clustering in ms sql server. So, Please Guide for
the same.
I am currently using ms sql server 2000 with service pack 3 installed
on it.
I already installed sql server 2000 and SP 3 on both the server where
the clustering should setup.
Thanks & Regards,
Sajid.See if this helps:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<csajid@.gmail.com> wrote in message
news:1148976451.207722.106000@.i39g2000cwa.googlegroups.com...
Hi,
I want to do database clustering in ms sql server. So, Please Guide for
the same.
I am currently using ms sql server 2000 with service pack 3 installed
on it.
I already installed sql server 2000 and SP 3 on both the server where
the clustering should setup.
Thanks & Regards,
Sajid.|||Hello, have you read
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
?
J
"csajid@.gmail.com" wrote:
> Hi,
> I want to do database clustering in ms sql server. So, Please Guide for
> the same.
> I am currently using ms sql server 2000 with service pack 3 installed
> on it.
> I already installed sql server 2000 and SP 3 on both the server where
> the clustering should setup.
> Thanks & Regards,
> Sajid.
>|||Hi,
First thanks for your reply.
I already gone through the link,
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
&
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
but i have some queries regarding both the articals,
1) Is it necessary to do windows clustering and network load balancing
before doing sql server
clustering. Who will do it ? SQl DBA or Win Admin. (In
Active/Passive Clustering)
2) As we want to do Active/Passive clustering so there is need to
create virtual server.
3) Is it necessary to installed ms sql server on both the servers which
are involved in clustering.
4) Please give me the simle steps to start sql server clustering.
Please reply to my queries. I am waiting for reply.
Thanks & Regards,
Sajid.
Julie wrote:
> Hello, have you read
> http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
> ?
> J
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > I want to do database clustering in ms sql server. So, Please Guide for
> > the same.
> >
> > I am currently using ms sql server 2000 with service pack 3 installed
> > on it.
> >
> > I already installed sql server 2000 and SP 3 on both the server where
> > the clustering should setup.
> >
> > Thanks & Regards,
> > Sajid.
> >
> >|||1) Is it necessary to do windows clustering and network load balancing
before doing sql server clustering. Who will do it ? SQl DBA or Win Admin. (In
Active/Passive Clustering)
A: Microsoft Clustering Services (which is a Windows component) needs to be
setup and configured before installing SQL Server on the cluster.
2) As we want to do Active/Passive clustering so there is need to
create virtual server.
A: There is always a need to create a virtual server. You applications will
use the virtual server name to connect hence making it irrelevant which node
is active at the time.
3) Is it necessary to installed ms sql server on both the servers which
are involved in clustering.
A: No. SQL Server will know you are installing on a cluster (if it's setup
correctly). You will need to have some essential information prior to
installing (like virtual server name and ip address).
4) Please give me the simle steps to start sql server clustering.
Have a look at this for step-by-step instructions (for Windows 2000/SQL
Server 2000):
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
"csajid@.gmail.com" wrote:
> Hi,
> First thanks for your reply.
> I already gone through the link,
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> &
> http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
> but i have some queries regarding both the articals,
> 1) Is it necessary to do windows clustering and network load balancing
> before doing sql server
> clustering. Who will do it ? SQl DBA or Win Admin. (In
> Active/Passive Clustering)
> 2) As we want to do Active/Passive clustering so there is need to
> create virtual server.
> 3) Is it necessary to installed ms sql server on both the servers which
> are involved in clustering.
> 4) Please give me the simle steps to start sql server clustering.
> Please reply to my queries. I am waiting for reply.
> Thanks & Regards,
> Sajid.
>
> Julie wrote:
> > Hello, have you read
> > http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
> >
> > ?
> > J
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > I want to do database clustering in ms sql server. So, Please Guide for
> > > the same.
> > >
> > > I am currently using ms sql server 2000 with service pack 3 installed
> > > on it.
> > >
> > > I already installed sql server 2000 and SP 3 on both the server where
> > > the clustering should setup.
> > >
> > > Thanks & Regards,
> > > Sajid.
> > >
> > >
>sql