Forum Discussion
SQL Migration from SQL2017 to SQL2022
AG1: Win OS 2016, SQL 2017 AG2: Win OS 2019, SQL 2022 We are trying to migrate database from AG1 to AG2 via distributed AG. As the database is on different version, the status of the db on AG2 will...
Here's what AI suggests:
SELECT * FROM sys.dm_exec_requests WHERE command LIKE '%RECOVERY%';
Ensure disk latency is low and CPU is not maxed out.
If log backups are missing or corrupted, you may need to restore from a good backup and rejoin the AG.
When adding a database to an AG, ensure it is fully recovered and log backups are up-to-date before joining. This minimizes "In Recovery" delays.