@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 4 years, 7 months ago by as_1234. Reason: Editted to include more of the error message

AlphaTangoWhiskey:

Thanks for your help. I don't think the account being used for any proxy or the SQL Server agent will be used when I'm running the package from Visual Studio?...

All,

Thank you for your help. The file is on the SSIS server.

As it looks like I need to rebuild the package I will try that. I won't get time for...

Can you advise which system is generating your alerts? Also is it installed on the same part of the network as the SQL servers?

Do the alerts happen at the same...

I think the information here https://docs.microsoft.com/en-us/windows-server/storage/storage-spaces/understand-quorum#dynamic-quorum-behavior (scroll down to 'two nodes without a witness) will help with your question?

I know that when I ran a cluster on Windows Server 2012...

I think you are asking why the secondary server was able to receive the data it missed during the downtime?

The process is explained here https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups?view=sql-server-ver15. In particular the section "How...

• This reply was modified 4 years, 8 months ago by as_1234. Reason: Corrected 'second' to secondary'

Sorry, I am not sure of your questions:

Are you asking us if this is a...

I don't know the cause of this but maybe the following will help work out the issse:

Can you run the following?:

select * from sys.dm_hadr_availability_replica_states

This should show the...

There is some guidance here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Did you mean how to set the 'month skip' column...

Thank you for your help. That did improve the plan.

I would also be interested to know if my reading of the original plan was correct.

Thanks

Thanks for your help.

I thought I added a comment both times but possibly not. Sorry, probably user error on my part.

I think it says no action is required because it can fix itself. However losing quorum is likely to be a potential problem.

What items are part of the Windows Server...