Assumptions

• Automatic Seeding

Add Database

Primary

CREATE DATABASE [myNewDB]

ALTER DATABASE [myNewDB] SET RECOVERY FULL

ALTER AUTHORIZATION ON DATABASE::myNewDB TO sa

CREATE LOGIN [MYDOMAIN\svc_myNewDB] FROM WINDOWS WITH DEFAULT_DATABASE=[myNewDB], DEFAULT_LANGUAGE=[us_english]

USE [myNewDB]

CREATE USER [MYDOMAIN\svc_myNewDB] FOR LOGIN [MYDOMAIN\svc_myNewDB] 

ALTER ROLE [db_owner] ADD MEMBER [MYDOMAIN\svc_myNewDB] 

ALTER AVAILABILITY GROUP MyAG ADD DATABASE [MyNewDB]

Secondary

CREATE LOGIN [MYDOMAIN\svc_myNewDB] FROM WINDOWS WITH DEFAULT_DATABASE=[myNewDB], DEFAULT_LANGUAGE=[us_english]