two undocumented Stored Procedures that allow you to process through all tables in a database, or all databases in a SQL Server instance http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

This would be run for each db in turn. 1. Pause log backup job 2. On primary – alter database [dbname] set partner off 3. On primary – ALTER AVAILABILITY GROUP [agname] ADD DATABASE [dbname] 4. On secondary – ALTER DATABASE [dbname] SET HADR AVAILABILITY…