2 active instances on 2 nodes at the same time SQL 2k5 Standard

#21

show "High Availability" table under
http://www.microsoft.com/sql/prodinf...-features.mspx

--
Aleksandar Grbic
MCDBA, Senior Database Administrator

"Tim J" wrote:

Quote:

I have a vendor telling me that I need the Enterprise version of SQL 2005 in
order to run an active/active cluster and that I can only run an
active/standby cluster on the standard version.

I've set up many clustered SQL servers on SQL 2000 Standards a few years ago
and never ran into any active/active or active/passive or questions.

I know I can only run 2 nodes in SQL 2k5 Standard.

Is there any reason that I can NOT run a 2 node cluster with separate but
active instances on both nodes at the SAME TIME on the Standard version of
SQL 2005?

E.G., instance A active on node 1 and instance B active on node 2 at the
same time on SQL 2005 standard?

Or do I need Enterprise level to do this?

Thanks,
Tim

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

2 active instances on 2 nodes at the same time SQL 2k5 Standard

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

RE: 2 active instances on 2 nodes at the same time SQL 2k5 Standard - 04-06-2008 , 04:11 PM