Sharing the solution with broader community!
Below is a summary of this case for your records:
Based on documentation provided to you, you have configured CS using OVA and we have installed mobility agent on source machine APP.
We have added VM to the replication and Initial replication was completed without App-consistent recovery point due to SQL writers failure.
On source VM, from SQL management server we have verified “AUTO_CLOSE” ON databases and found 2 DBs and then we have turned off “AUTO_CLOSE” for the same. Please refer following documentation for more details & SQL queries https://learn.microsoft.com/en-US/troubleshoot/sql/admin/revocery-jobs-fail-servers
After turning off auto_close, we have recycled SQL VSS, ASR VSS & ASR services and could see SQL writer tuned into stable state.
Initiated App-Consistent recovery point manually from C:\Program Files (x86)\Microsoft Azure Site Recovery\agent>vacp -systemlevel and its completed
We have initiated test failover using latest App-Consistent recovery point, Assigned public IP, assigned NSG rules & connected using RDP. Please refer below documentation for Test Failover & Failover.
Test Failover: https://learn.microsoft.com/en-us/azure/site-recovery/tutorial-dr-drill-azure
Failover: https://learn.microsoft.com/en-us/azure/site-recovery/vmware-azure-tutorial-failover-failback
Please follow above documentation for test failover & failover
Please note that for Physical to Azure Scenario, you can’t failback from Azure to On-prem.
---------------------------------------------------------------------------------------------------------------
If the response helped, do "Accept Answer" and up-vote it.