locked
CRM 2011 high availability database without shared storage RRS feed

  • Question

  • Hi everybody,

    we have a CRM 2011 setup with two clustered SQL 2008 R2 databases that get the disk resources from a shared storage (EMC).
    This setup works totally fine and helps us guaranteeing high availability.

    Now we have the request to put up a second deployment but without having a shared storage.
    To me that means that the possibility of a SQL Cluster is gone, too.
    Or is there a possibility to build a cluster without any shared storage?

    The alternatives like database mirroring and replication do not seem to be fitting, because I would have to reconfigure the CRM application servers to connect to another SQL server.
    Not to mention the hastle with the SPNs etc.

    What other possibilites do I have to guarantee high availability without having a shared storage?

    Thanks for your advice,
    Thorsten

    Wednesday, August 8, 2012 3:53 PM

All replies

  • SQL clustering using shared storage provides the greatest availability. CRM is aware of database mirroring, so you can use synchronous mirroring with a separate witness server, which provides automatic failover, but has a performance impact.

    Overall, there is always a trade-off, either in cost, or performance impact (which you alleviate by paying for more powerful hardware), for greater availability


    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Thursday, August 9, 2012 5:10 PM
    Moderator