Using CTE with SQL
You must stop the SQL service before guarding the SQL DB. When this occurs, the SQL Server replication may become unsynchronized. When restarting, it may take a brief period of time for the SQL Server replication to resynchronize with the other node. The SQL Server issues a warning against any attempted failovers during that brief period.
Note
Minimizing the duration for which the SQL Server service is stopped is beneficial for reducing the resynchronization period.