I would first review the permissions for the proxy account that calls the package.

You are reading the msdb database and master databases

I would start by down loading Glenn Berry s diagnostic queries and running these.

With page life expectancy, look at the long term trend. See Jonathan Kehayias blog about it in...

There is automatic seeding and lag time. Can you be more specific as to what you need?

Can you use Set instead of select

Or rewrite your query

Select * from customer_orders where order_id = (select max(order_id) from dbo.orders)

To get information for this, you can query with T-sql:

Select auth_scheme,  local_tcp_port, @@servername, SERVERPROPERTY('MachineName'), SERVERPROPERTY('InstanceName') From sys.dm_exec_connections where session_id = @@spid

And

Select servicename service_account from sys.dm_server_services

So you need to go back a year? I would see what there is in msdb.dbo.sysjobhistory

Run a query to see what is in those rows. Perhaps it is empty spaces that you can update to 0, or 'null'.

You could also use the case statement when...

Add account

Create credential for the account

Create proxy in sql server agent for that account

Call your job step with that proxy

Grant that account access to the network share

Does your connection string include applicationIntent= read only?

Have you configured read only routing?

What account is calling the package?

My first guess is to check the sql account

Did you do an in place upgrade?

Can you run: Select name, physica_name from sys.master_files where database_id = DB_ID('ssisdb')

Thank you for this well written article.

I like your links. I have to say that the longer you work with databases, the more likely you will overlook the application front...

No. Move the ,nd file manually on the secondary

Is the database synchronizing on each node?

Sql agent job step type: powershell

Switch-SqlAvailabilityGroup -Path SQL SERVER:Sql\othernode\instance\AvailabilityGroups\AGName -ErrorAction Stop -WarningAction SilentlyContinue | Out-Null

Schedule as one time run

Run as sys admin, sql agent account

How big is your database? Youu could log ship to both replicas.

After bringing database online on the primary, do an xlog backup and restore that on the secondary. It speeds...