HI All,

can any one reply on this when primary is down and not accessible also failover not occurred to secondary and size of the database is huge client dont...

Google is your friend

Aside what Fredrico stated, setup a credential and proxy for the agent job step exec type and run the job step under the proxy ensuring it has permissions granted where...

Each product page lists the OS requirements and upgrade paths, compatibilities, etc. Example here

https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019?view=sql-server-ver16

Which system databases did you copy?

all I can do is point out that SMKs and DMKs should not be restored across instances and if done correctly there’s actually no need...

Comment out the if block and try printing the contents of the $Row var see what’s inside it

OP confirmed that already, likely lack...

Glad you got it resolved Brandie

I believe the truncate needs to take a sch-m lock on the table, not just the partition. Even switching the partition into an empty holding table requires the same...

And the user just informed me that two of the four lines I found are "old" services. Which makes me wonder if this isn't the source of her testing...

that too, but more overhead than required considering partitions can be slid out

Why are you truncating partitions and loading them why not just use the partition sliding window to move partitions along and drop any you don’t need

I guessed so if agent is running under that too, so have you checked the ACLs at the...

there is an Auto_Stats ext event under the execution category, track the incremental and sample_percentage columns

if   (Test-Path -Path  "$($Row)")
    {
      Throw "File exists"
    }