Re: Sql serve clustering

Thanks, Is that true database mirroring in sql 2005 only allow one db in one
server?
It won't work for multi-dbs

"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:equNgIHHGHA.208@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> We are planning to have sql server failover clstering.
> Since server failover clustering is only for hardware redundancy not the
> databases. I still need 2 physical sql boxes(primary one is cluster
> server) by using replication or log shipping.
> My question is that why I need a expensice cluster server instead of
> regualr sql server?
>
> 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)
Loading