Get well soon, Ken

have a look at Scope: The drastic caveat with Logon Triggers

We have automated weekly restores ( including checkdb ) .

This target server has a C-drive and one big raid-0 volume as that is its only purpose.

It holds max 2 user...

That's wonderful news, Kendra and Jeremiah.

Keep in mind, your dogs immigration will need some time too, maybe even a quarantine time.

All the best in the UK

and, depending on your view definition, the result must also meet the view specifications !

( With check option )

ref: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-ver15

Please upgrade to the latest CU ! You are missing essentials and RTM already had a mandatory hotfix at launch time !

https://support.microsoft.com/en-us/help/4536075/cumulative-update-2-for-sql-server-2019

Please let me know if that helped !

Good points !

what edition are you using ? Std edtn  vs Ent edtn ?

( No backups on secondary replica with basic AGs ( = std edtn ))

• This reply was modified 5 years, 7 months ago by Johan Bijnens.

What did you test ?

logically step-1 determine the max CreatedDate per orderid

logically step-2 update all rows for the given orders that do not have CreatedDate equal to the max_CreatedDate for...

Before you do that. What is your goal ?

I would suspect the AD SPN.

I recall our cluster losing full control over that object during our tests.

Broke it down and rebuilt it. Never happened again. We built 10+ 2node...

Did you enable the AlwaysOn XEvents session on all involved instances?

Did you install a monitoring solution to get an overview of failover events,..

I have a sqlagent job that is launched...

did you check with all prerequisites ?

Prerequisites, Restrictions, and Recommendations for Always On availability groups

• This reply was modified 5 years, 7 months ago by Johan Bijnens.

BTW What's the advantage of an AG if you really need it to be hosted on a given server ?

It should be consumable in either situation.

Check the SQLServer errorlog file !

Try the failover to A manually in SSMS and see what error comes up.

Implement failover monitoring so you can see which fases it passes or...