I run a multi-tenant application : each client runs the same code but each one hase its own database for personnal parameters and data, that makes about 40-50 databases and growing (i hope so)
I want to set up a high availability strategy, for that, I have two VMs each one running SQL Server 2008 Entreprise.
I had started to configure log shipping, but I was told that it was not a good idea when there are many dbs involved.
How can I choose between HA strategies ? What tests do I have to do to see if i'm still elligible so log shipping (number of transactions per hour ?)
If log shipping is not an option, what should I choose ? Failover cluster ?
Thanks ! Don't hesitate to ask if you need more information.
View Complete Post