It sounds like you might be trying to run queries on the secondary server?

Are you using Standard or Enterprise edition?

In terms of a separate NIC - I can't give you a specific answer but we had something similar which you might need to look out for. The servers were...

The Stairway that Grant mentions is here https://www.sqlservercentral.com/steps/stairway-to-alwayson-level-1-what-is-sql-server-alwayson and is a good guide. The first level gives a good overview as well.

Thanks for your reply and sorry for my slow reply.

It is Ubuntu 16.04.6 LTS.

Hello,

Can you post some table data as detailed here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help ? It enables people to give more accurate answers.

I'm wondering if your question could be solved with a self join...

If possible it might be useful to see which roles are configured on the cluster? That might give us an idea what's going on. From memory (I don't have access...

I think I'm correct in saying that it will sort it because it's running a log backup but it doesn't explain the cause of the original problem. As you probably...

You need to have a look at the Windows Cluster manager for the Windows servers that SQL is running on. As you may know 'Always On' relies on a cluster...

Hello,

When you say "I have Transaction logs backed up by SQL H ". Which method are you using for this? Log shipping?

Sorry I'm not sure of the cause of the...

You've probably already checked this but if the other tasks are deleting from other folders then could it be a difference in permissions? Either on the folder itself or the...

Thanks for a useful article.

A related question (please advise if it would be better as a separate topic) would be if it's possible and, if it is, how to work...

I can't give you a full answer but for identifying if the database is part of a group maybe you can query sys.dm_hadr_database_replica_cluster_states (https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-hadr-availability-group-states-transact-sql?view=sql-server-2017) using the database_name field...

Following on from Steve's comments - maybe there is an entry in the local hosts file so if you ping/try to connect by name you aren't actually connecting to the...

Possibly there are more VM's on the larger luns and there isn't so much bandwidth available for the SQL vm's? On a system I used to administer I found there...

I don't think you can move a file with the database online (Microsoft reference here https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-2017 ).

Others may have better ideas but what you might be able to do is...