Mixed feelings about the logging. Sometimes it's just "Unexpected termination".

Wow, running sql server 2005. Maybe it's better to setup a new 2019 and restoring the data. TLS 1.0 en 1.1 are getting obsolete fast.

Regarding linked server: did it work...

MS knows the answer and MS can vouch for it. Best route is to contact MS

As far I can read is that if you have SA (subscription) you're allowed one...

Lately there was some visibility because of an Apple OS bug. We've found a rather annoying bug that allows remote takeover, patch asap

And the implemented solution is / was?

That's why we are still using VM's. Containers / K8 are next level in management

I'm not familiar with AAG groups or replica's.

As you're working with AAG's you might get funding for a MS support call / consultant to sort it out

I would also go on the route of permissions. Perhaps you're not seeing all the files. (difference between user and "run as administrator")

Ask the vendor of the tool for help?

Is the database "offline" or the folder "" offline?

Have you tried fiddling with the folder permissions ( perhaps the tool, sql server, your...

No, SSAS keeps the memory as it is usefull for caching. It will try to keep a minimum of free memory on the server. When lowmemory is triggered, start cleaning...

We only have one server with one catalogue.

We use it to override settings that may come from deployments. New project -> Configure -> Link to environment. You may not need...

Retry logic in SQL is difficult as there may be errors that kills your session. You could use try catch but it's still tricky

https://www.brentozar.com/archive/2022/01/error-handling-quiz-week-making-a-turkey-sandwich-with-xact_abort/

I don't have synapse to test with.

Collation confict can be resolved by forcing a specfic collation in your query

http://www.ashishblog.com/how-to-resolve-the-collation-conflict-and-how-to-check-collate-in-sql-server/

It could be that the collation of tempdb ( as you...

Apperently it can with an alter statement

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/28ee3de6-9dc7-4f4a-9663-cafa531d64c2/tde-how-to-change-encryption-key-algorithm-from-128-to-256

Thanks for the deep dive