Hello,

Thank you for your help.

Are both servers running the same SQL Server version?

Are both databases using the same compatibility level?

Are both databases using the same transaction isolation level?

Are both...

All,

Firstly apologies for posting a question and not replying. That wasn't my intention. Some unexpected issues took my time.

The reason for renaming is that the backup will be picked up...

• This reply was modified 1 year, 2 months ago by  as_1234.
• This reply was modified 1 year, 2 months ago by  as_1234. Reason: Two typing errors corrected

All,

Thank you for your help and apologies for not replying. Another issue has taken my attention and I haven't had chance to reply.

I will reply to everyone's questions soon, probably...

All,

Thank you for your help.

I was able to capture all the information I need using Extended Events.

Just an update in case it's useful to anyone:

Scripting the database doesn't show any relevant permissions.

If you unversion the table the insert permission isn't shown in SSMS. If you re-version...

All,

Thanks for your replies.

Scripting out the database is a good idea, I'll try that.

I'll carry on investigating and if I find an answer or anything else that might be useful...

Sorry for taking so long to reply.

I don't get an error from that command.

I did some testing on a test system. I created a table as follows:

CREATE...

• This reply was modified 1 year, 7 months ago by  as_1234.

I haven't tested this but maybe it requires one of the SSIS permission roles? I think this is the relevant documentation https://learn.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver15

As I said not tested and some...

Sorry for my slow reply.

I created the user from login. At the server and database level they are only in the public role and I can't see anything relevant allocated...

I am not 100% sure but I think the problem might be as follows:

The log file from the primary server isn't applying to the secondary server which will cause the...

All,

Apologies for my slow reply. Thank you for your help.

Does the WSFC tell you why it fails to bring the AG resource online? I haven't done clustering for a while but I seem to remember there is a log/event...

Thanks for your replies.

In this case there are valid reasons for turning it off. We don't need an unchangeable audit.

I am also looking at using other methods for creating a...

Thank you for the suggestion. Sorry I forgot to mention this possibility in my original...

• This reply was modified 1 year, 8 months ago by  as_1234. Reason: Trying to fix quote tags

I can't answer this directly because I haven't used SQL Server 2022 however a question which might help other people answer:

You've said that both databases are getting the same data....