SQL Always On Availability Group Deployment

Marcus Wong Theen Nam 1,131 Reputation points
2020-09-09T10:00:51.24+00:00

Hi there,

I would like to setup a SQL AlwaysOn Availability Group on 2 new SQL servers. For the storage part, as I know SQL AG doesn't require shared storage for the database replication. However, if I want to use LUN on my servers to expand the storage, can SQL AG still be configured with shared storage? Like example below:

There will be 2 LUNs
Server A attached to LUN A
Server B attached to LUN B

Will above storage settings work for SQL AlwaysOn Availability Group configuration as they are not sharing the same LUN.

Thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,986 questions
0 comments
Accepted answer
  1. Shashank Singh 6,251 Reputation points
    2020-09-09T11:23:58.287+00:00

    Yes they will work without any issue. Like you said plain SQL AG does not needs shared storage so the working of both the storage would be mutually exclusive and hence you can have different LUN's

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,271 Reputation points
    2020-09-10T06:08:02.89+00:00

    Hi @TheenNamWong-9726 ,

    Will above storage settings work for SQL AlwaysOn Availability Group configuration as they are not sharing the same LUN

    Yes. They will. And what you are considering is very import to configuring AlwaysOn Availability Group.

    More information: step-by-step-creating-a-sql-server-always-on-availability-group

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. m 4,271 Reputation points
    2020-09-11T01:32:39.913+00:00

    Hi @TheenNamWong-9726,

    Is the reply helpful?

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.