You will need to convert the time aspect into a time only column then filter out where >= 6 and < 18, something like the below.

            
October 16, 2017 at 6:49 am
            
#1963805

            
            
                                                
        

What errors do you have in the Windows event log and also the cluster log?

There will be some information in those logs which will detail why the role...

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...