quickstart-microsoft-sql icon indicating copy to clipboard operation
quickstart-microsoft-sql copied to clipboard
verified publisher icon aws-quickstart

Problem with SAS Volumes

Open tmustain opened this issue 7 years ago • 2 comments

Heads Up: I had to add a couple of extra steps to get this to work correctly. Apparently failover clustering by default will assume all SAS volumes are meant to be shared cluster storage and try to commandeer them, which makes SQL unable to come up because its data and log volumes aren't mounted. Workaround is essentially to release them with the Failover Cluster Manager and then bring them online with Disk Management:

https://blog.sqlauthority.com/2016/11/08/sql-server-added-new-node-windows-cluster-alwayson-availability-databases-stopped-working/

https://support.microsoft.com/en-za/help/2813005/local-sas-disks-getting-added-in-windows-server-2012-failover-cluster

tmustain avatar Sep 18 '18 14:09 tmustain

@tmustain I'm getting a similar issue. Was able to get it to manually work.

ghost avatar Sep 29 '18 06:09 ghost

I apologize for not responding sooner, we recently made some updates to this Quick Start. Can you verify if you see this issue still existing? We did drop support for Windows 2012 in the quick start, and support Windows 2019. Please let us know if this still exist.

virtlima avatar Jun 26 '19 14:06 virtlima