SQL 2005 active/passive - multiple instances

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

I have a SQL 2005 cluster as the backend of my OCS 2007 environment. It is a
shared server. I recently found information that the OCS DB should be on its
own SQL server, or at least its own instance with dedicated spindles for the
data and log files.

The cluster its on now is shared so I guess I'll need to create a new
instance.
Not having a huge SQL clustering background I did a little googl'ing and i
found some messages saying that instances are not support in an
active/passive cluster.
Is this true?

Thanks in advance!!!


.

Relevant Pages

  • Re: SQL 2005 active/passive - multiple instances
    ... The "dedicated" requirement is typical developer misunderstanding of SQL. ... A properly designed and tuned SQL server can handle all the back-end database functions of OCS without having to build umpteen-jillion dedicated instances/servers. ... Not having a huge SQL clustering background I did a little googl'ing and i found some messages saying that instances are not support in an active/passive cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 active/passive - multiple instances
    ... While it is true that you should separate high volume db files onto separate spindles you should look at the metrics to determine if this is necessary or not. ... You would be best to determine why and if you need to do anything before going to the extreme of adding another instance to your cluster. ... a shared server. ... I recently found information that the OCS DB should be on its own SQL server, or at least its own instance with dedicated spindles for the data and log files. ...
    (microsoft.public.sqlserver.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: Clustering Newbie - SAN Advice
    ... Senior SQL Infrastructure Consultant ... SAN/Smart array or through a fibre channel switch. ... The SAN or Smart array will dictate what internal connection the disks ... single-instance cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)