none
cluster and standalone RRS feed

  • Question

  • we builted active/passive node windows server 2012 and sql server 2012 with shared storage data,log and backup.

    can we install standalone instances on active node and can we use the shared drives?

    please help me

    • Moved by Kalman Toth Saturday, October 18, 2014 3:16 PM Better fit
    Saturday, October 18, 2014 12:13 PM

Answers

  • When the cluster fails over, the shared drives won't be available from the node and your standalone instance will not start. You can install the standalone SQL instance on the local drives but it might also create unnecessary complications during patching as patching entails upgrading the shared components of all SQL instances. Also, you would have to account for these standalone instances when setting SQL max memory such as you should consider the worst case when all instances are running on the same node along with standalone instances. 

    Satish Kartan www.sqlfood.com


    A short answer would be that it is not recommended

    Satish Kartan www.sqlfood.com

    Saturday, October 18, 2014 1:33 PM

All replies

  • When the cluster fails over, the shared drives won't be available from the node and your standalone instance will not start. You can install the standalone SQL instance on the local drives but it might also create unnecessary complications during patching as patching entails upgrading the shared components of all SQL instances. Also, you would have to account for these standalone instances when setting SQL max memory such as you should consider the worst case when all instances are running on the same node along with standalone instances. 

    Satish Kartan www.sqlfood.com


    Saturday, October 18, 2014 1:26 PM
  • When the cluster fails over, the shared drives won't be available from the node and your standalone instance will not start. You can install the standalone SQL instance on the local drives but it might also create unnecessary complications during patching as patching entails upgrading the shared components of all SQL instances. Also, you would have to account for these standalone instances when setting SQL max memory such as you should consider the worst case when all instances are running on the same node along with standalone instances. 

    Satish Kartan www.sqlfood.com


    A short answer would be that it is not recommended

    Satish Kartan www.sqlfood.com

    Saturday, October 18, 2014 1:33 PM