Theres a number of ways, create a normal SQL maintenance plan adding in the relevant tasks.  Use Ola Hallengren's scripts, look at MinionWare, or write your own routines.

Personally...

What edition of SQL are you running Enterprise or Standard, just double checking as you said "Standard AG Database" and TDE is not available in Standard edition.

If you...

You need a standard Windows Failover Cluster to do Always On Availability Groups, be that a domain joined, multi domain joined, domain independent or a workgroup cluster (last 3 as long...

Is the stored procedure trying to go cross database?  So while you may be creating it in a database that is not in an AG, it may be doing some...

Thanks Steve.

Tried adding the thumbprint but then the service wont start with the error "TDSSNIClient initialization failed with error 0xd, status code 0x38. Reason: An error occurred while...

OK, so the individual certificates didn't work either.

Certificate imported fine into MMC, permissions granted, but SQL Config Manager still doesn't want to acknowledge the fact a certificate is...

Just had a look at Derek's blog, he doesn't create the certificate for the cluster, but for the individual machine with the AG as a SAN, will get the clients...

Hi Steve

Yes the cert is for the FQDN, example CN = Cluster.mydomain.com and the SAN = Cluster.mydomain.com, AG1.mydomain.com, AG2.mydomain.com

Will take a look at the links and...

So tried to set this up again on a brand new clean test cluster with 2 AOAG's, again the cluster doesn't like the certificate.

Tried doing it stand alone...

fn_dump_dblog will be the table valued fuction to go for


select *
from fn_dump_dblog (NULL,NULL, N'DISK', 1, <PATH TO TRN>, DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT)


From that you can see the transactions...