Active/Passive Production with Test Instance

#1

I am trying to setup a SQL cluster with the an
active/passive cluster for production. On the passive
node, I have been told to create a separate disk and
install a developers edition of SQL to use as a test
environment. The developers edition will be a named
instance of SQL to help isolate it from production should
a failover occur.

Does anyone else out there have this type of
configuration in their environment? Have you had any
problems or does it work fine? My gut is not real
comfortable with this, even though we can make it work in
a test lab. I would appreciate any other feed back to
make me feel better, or help me build the case to do
otherwise.

Thanks

#2

Quote:

-----Original Message-----
Dan,

Reading your description, it appears that you want a
production clustered SQL Server instance on one node

(that you call active) and another test clustered SQL
Server instance on second node (that you called

Quote:

passive).

Actually, the test instance of SQL would not be
clustered, but exist solely on the second box. We do not
plan any failover for the test instance.

This will work but then it is not really active/passive,
it will be active/active configruation. Basically you are
planning to install two clustered SQL Server instances on
a two node cluster and each instance

Quote:

running on seperate nodes. There is no issue in doing
this except that you will need make sure that at any time

the resources on a single node is enough for both the SQL
Server instances.

Quote:

SQL Server 2000 Failover Clustering is a High
Availablity solution. Hence, one would not want to have

production and test instances on the same cluster. I
would not recommend having prod and test on same cluster

Quote:

and I have not seen this. I have seen many clusters with
two instances of SQL (infact 16 instances are supported)

on the same cluster but all the instances are for
production and they are configured such that even if

Quote:

one node fails the other node can run all the instances
without any issues.

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and
confers no rights.

Are you secure? For information about the Strategic
Technology Protection Program and to order your FREE

Security Tool Kit, please visit
http://www.microsoft.com/security.

Quote:

Microsoft highly recommends that users with Internet
access update their Microsoft software to better protect

against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites:

Quote:

http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Active/Passive Production with Test Instance

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Active/Passive Production with Test Instance - 09-16-2004 , 10:25 AM

RE: Active/Passive Production with Test Instance - 09-16-2004 , 01:24 PM