question

Venkataraman avatar image
Venkataraman asked

Can Primary and Secondary servers of Always on availability group can share the same SAN storage?

If I configure Always ON availability group, whether Primary and Secondary servers use the same SAN storage ? Generally, it is not advisable as per http://www.brentozar.com/archive/2011/07/how-set-up-sql-server-denali-availability-groups/ . But, my question, whether it is possible to configure Primary and Secondary servers to use same SAN storage ?
always-onavailability-groupsconfigurationsanstorageareanetwork
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Sure. You can configure them to use the same storage. It's just defeating the purpose of having an availability group instead of a failover cluster.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
I guess the main benefit would be the ability to have zero downtime patches for OS and SQL.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Not sure how that would result in zero down time. You still have to fail over from one machine to the other while patching causing disconnects.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.