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, 1 month 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....

I haven't worked with WSFC/AG for a while and I don't have access to a test system but, if I remember correctly, the WSFC cluster provides a reason why it's...

All,

Thank you for all your advice it is very useful. I have attached the execution plans as txt files

• This reply was modified 3 years ago by  as_1234. Reason: The site didn't allow me to attach .txt files. So I will try .sqlplan

In addition to the advice above. One thing that might be worth checking, if you haven't done already, is pinging the DNS name and see whether it returns the IP...

Apologises I was thinking that the rows you need to check might all be new or have been updated. As you said it won't pick up existing, unchanged, rows.

Taking a significantly different angle on this and apologises if it's too far outside of the scope of your question but could you use Change Data Capture to identify changed...

Sorry for my mistake. I am having another look at your question and I noticed something:

You said that you need to keep the items marked yellow in your attachment. On...

I think the following might give you the data rows you need?:

declare @sampledata1 table

(

[Date] date ,TC1 varchar(100),Amount_New decimal(10,2)

)
INSERT INTO @sampledata1

([Date]

,[TC1]

,[Amount_New])

VALUES ('2020-11-01','Houses:N-Home',70),

('2020-11-01','Houses:N-KL',80),

('2020-11-01','Default Category: Default Option',90),

('2020-11-01','Houses:NS-Home',22.5),

('2020-11-01','Houses:N-KL',45),

('2020-11-01','Houses:N-GR',22.5),

('2020-12-01','Houses:N-Home',100),

('2020-12-01','Default Category: Default Option',250),

('2020-12-01','Houses:N-Kl',110),

('2020-12-01','Houses:N-Home',24),

('2020-12-01','Houses:N-KL',12),

('2020-12-01','Houses:N-GR',60),

('2020-10-01','Houses:N-BR',24),

('2020-10-01','Houses:N-KL',12),

('2020-10-01','Houses:N-GR',60),

('2020-10-01','Houses:N-BR',24),

('2020-10-01','Default...

People tend to be wary of opening attachments, especially from new users. Can you put the expected result into a post?

It might also help if you can provide test data...

@AlphaTangoWhisley - No problem

All:

The 'failed to lock' runtime error on the file operation was my error. I had the expression for the filenames specified in the source and destination properties...

All,

Thanks for your help. I think I solved the issue by repairing Visual Studio. I thought it was my error rather than an issue with the software but perhaps not.

Since...

• This reply was modified 3 years, 2 months ago by  as_1234. Reason: Editted to include more of the error message