福
福
> And please add an entry to README.md about 2 new variables sorry，today is my first pr in my life，i will commit README.md later
is work in my test，this is final version of configre_ag.j2 if you do not have any suggest，thx
ok i just upload my inventory and playbook，if have any question ask me please
you must create ag to verify it and can verify it through this sql `select name,is_contained from sys.availability_groups` if is_contained = 1, mean is work
i try to write task and i hope to help you ` tasks: - name: Ensure mssql_version is 2022 block: - name: Check if mssql_version is 2022 assert: that: -...
> Is there a way to read the value of `REUSE_SYSTEM_DATABASES`? I think cant't,but it will create tow new database `ag_name_master` and `ag_name_msdb` like `ExampleAG_master` and `ExampleAG_msdb` in this playbook...
> @zhuatuzilo thank you for the submission. Can you please explain a little bit more about what exactly this change does, why it is needed, and what it allows the...
Hi guys，can we merge this pr? If have any suggestion，tell me plz. @spetrosi @richm
you can refert this table: is_contained | reuse_system_database | ag's system db | result -- | -- | -- | -- true | true | exist | create ag successful,...
If `mssql_ha_ag_is_contained and not mssql_ha_ag_reuse_system_db`, because of the command `DROP AVAILABILITY GROUP {{ mssql_ha_ag_name }}` without drop ag's system db, so we must drop ag's system db which is existed...