Configure Always On - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Availability Groups and DR (2012)

Configure Always On

Author

Topic

Vishal4588
Starting Member

1 Post

Posted - 2014-06-27 : 04:06:33

Hi All,

I am new in this forum. I have one doubt related to Always On. One one my client database we have three instances (Example: A, B, C). He want me to move all instances in separate servers and then implement Always On for all three instances.

Example:
Server X: Instance A
Server Y: Instance B
Server Z: Instance C

But apart from these three server we have only one server (Stand By server D). Client want us to create three instance in StandBy server and configure Always On with all primary servers.

Example:
Primary || Stand By
====================
Server A: Server D
Server B: Server D
Server C: Server D

I am not sure whether we can implement this type of scenario (Many to One).

Please let me know if you need any more information.

Regards,
Dev

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-27 : 14:24:35

Yes you can do that but all 4 servers need to be in the same Windows cluster. You would create 3 Availability Groups for A, B, and C and then each of those would use D as the secondary replica.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources