Good point, if I: is a mapped drive of a network share, the mapping may not exist for the user the backup job is running as.  UNC path name is...

I could see an issue where if someone increases SQL Server's Max Server Memory too high, such that there is not enough free RAM left for the OS to run...

You will want to recreate the logins instead of renaming them, since Windows authenticated logins have a sid in the sys.server_principals that ties directly to the objectSid of the AD...

Can you tell us what indexes currently exist on the 3 tables?  If you could give us a .sqlplan file or .pesession file with the execution plan of the query...

Hopefully the OP will get back to us with more information then on the commands used in the job.

Here's a script I use to generate a MERGE statement for such a case.  Run this in the source database, and just change the first 3 lines to indicate the...

What I tend to do is use the Alerts ability within SQL Server Agent to get notifications of errors.

https://docs.microsoft.com/en-us/sql/ssms/agent/alerts?view=sql-server-ver15

You can setup an Alert for errors of severity 19 through...

do you have audit columns like LastModifiedTime or something that you could use to help the MERGE?  I've done some data marts and smaller data warehouses using the MERGE or...

It seems odd to me that the path name in the error seems to have the slashes doubled.  it says:

I:\\CM\\MaintenancePlan2_Subplan...

when I expect it should say:

I:\CM\MaintenancePlan2_Subplan...

Unfortunately unless you do something like Ken suggested, there isn't an easy way to do it inside the CATCH block.  Is the backup part of a SQL Agent job?  SQL...

Are you sure the AD group was deleted from AD and not just renamed or moved?  A way to check would be to use sys.server_principals to find the sid, and...

When looking at the dynamic management views, total_worker_time is CPU usage, you would have to look at total_elapsed_time to find the duration the query executions were actually running.  Does this...

CREATE TABLE #Customer (
    cust_id int identity(1,1) primary key not null,
    cust_name varchar(40));

INSERT INTO #Customer
    VALUES ('Fred'),('Wilma'),('Barney'),('Betty');

CREATE TABLE...

The second requirement, to display randomly selected characters to the front end, seems a bit odd.  Typically a password would be stored with a salted hash, not with encryption.  Theoretically...

that report uses the default trace, if the service hasn't been restarted in a long time the trace may be quite large.  You can see how long it has been...