June 2, 2016 at 3:03 pm
Hi,
I looking for documentation how bypass limitation of installation of standalone instance(s) on shared disks of MFC
(we do not discus managing clustering at this point)
At the end I want to have 2 node cluster with standalone sql 2014 on each node sharing drive D:, cluster will be managed by custom powershell
Installation of standalone on cluster stop at point when I choose to install on shared drive D:
Thank you
Alex
June 3, 2016 at 9:52 am
is there any reason why you want to achieve this way.
June 3, 2016 at 2:42 pm
one of the reasons
running multiple instances of SQL standard edition on same clustered shared drive
control over failover
June 3, 2016 at 10:26 pm
i dont think you can achive this.
June 4, 2016 at 5:11 am
I think you are asking for trouble trying to do this. A stand-alone instance will expect the drives you install SQL on to always be available and present. By nature a shared cluster drive can and most likely will move between cluster nodes when failover occurs.
If you try and install a stand-alone instance on a shared cluster disk that will move between instances at best you are engineering a design that is meant to go down when you probably do not expect it to. At worst you might be engineering a design that will lose data.
Joie Andrew
"Since 1982"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply