Re: Transactional replications to a server I plan to cluster

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

From: Roust_m (roustam_at_hotbox.ru)
Date: 10/22/04 

Date: 21 Oct 2004 23:25:41 -0700

The name of my present SQL Server is Server1, I will be using the same
name for one of the cluster instances. Will the replications start
after I cluster the server?
 
"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in message news:<u6mIGa2tEHA.3088@tk2msftngp13.phx.gbl>...
> You can't use the same name on two instances of SQL at the same time. You
> can use a SQL cluster to house transactional
> replications.
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
>
> "Roust_m" <roustam@hotbox.ru> wrote in message
> news:a388fd78.0410210300.c365e24@posting.google.com...
> > Hi!
> >
> > I have a server I am planning to cluster. I will be using the same SQL
> > server name for this cluster. I have a large number of transactional
> > replications to this server from a dozen of other servers. Will these
> > replications work evenly after the clustering? (All my servers are MS
> > SQL2000 sp3 + Win2000 Server sp4)
> >
> >
> >
> > Thanks.

Relevant Pages

  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connecting to cluster instance from .NET
    ... I have tried using the SQL 2000 CD and i have ... Virtual IP addresses for the cluster resource groups. ... SQL Server will listen on only those IP addresses ... This is odd because the 172.16 network is a Class B ...
    (microsoft.public.sqlserver.clustering)