SQL 2005 Failover

[Robert123]

Hello,

Thank you for your nice Information. I like it very much.

Thanks

[MercutioUK]

Is there anything in MS SQL that works similar to Oracle RAC? I do admin on a pretty hefty oracle DB estate (7000ish databases, everything from 2/3GB DB's up to 200TB data warehouse stuff) and RAC does what you're after (so i'd assume MS will have something similar).

1 data storage area
4/5 nodes running an instance of the database each, talking to each other and all tapping the same underlying data files. We have some pretty funky setups that work rather like MS SQL polyserve with a cluster running several instances that can happily move from node to node depending on what works best for resource usage.

[Moby-Dick]

RAC is a very different beast to MSSQL clustering - it allows clustered instanced for not only high availability , but for performance too.