Configuring SCCM to use SQL AOAG - Need help if something goes wrong during this step

Question

Dear Team,

We have installed the SQL standalone and now we are going to move the DB to SQL AOAG group with help of SQL team.

Concern is in the Microsoft article(attached) it says to run setup and modify the SQL Configuration setting at wizard with listener name however if this doesn't gets completed and we faced an error what will happen to the running primary site? Would that break the connection with standalone SQL?

In case, it really breaks the connection then is the site recovery only option? Please suggest best possible approach here.

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/configure-aoag

Answer 1

Hi,

I understand your concern about the potential issues that might arise during the migration of your SQL standalone to a SQL Always On Availability Group for your SCCM site.

Here’s some information that might help:

1. During the Migration: If an error occurs during the migration process, it could potentially disrupt the connection between your primary site and the standalone SQL server. This is because the migration process involves changing the SQL configuration settings to use the listener name of the AOAG.
2. Post Migration Failure: If the migration fails and the connection is broken, the primary site might not function as expected due to the lack of a database connection.
3. Recovery Options: In case of such a failure, one of the recovery options is indeed to perform a site recovery.
4. Precautions: Before starting the migration, make sure to take a full backup of your site database. This backup can be crucial for recovery in case of any issues.

I hope this information helps! If you have any more questions, feel free to ask. 😊