You should use backup and restore for nightly sync. T-SQL alone can’t access Azure’s automated backups, so automate restores via T-SQL scripts, PowerShell, or Azure CLI.

The trigger likely joins only on ParentId, causing old child records to be logged. Fix it by joining on both ParentId and ChildId and handling multiple rows correctly. Use Extended...

Azure Query Editor only shows the last statement’s result and may timeout after 5 minutes. Cursors produce intermediate results that it does not display. Run cursors in SSMS or Azure...