Hi Jeff,

That is strange.

I hoped the 'insert/edit code sample' would nutralise all dodgy behaviour of ampersants, etc

-- please see attachment

Keep min mind, with non simple recovery models, transactions are only flagged overwritable during a LOG backup !

To keep your log file size under control, it may require more frequent...

This script gets me all jobs and schedules that have "%backup%" in their steps command.

Just modify to the wanted database name and off you go.

select  ServerName
...

Keep in mind you will need to do some extra validation if to see of jobs address database objects using 4-part naming.

So, the query you'll end up with using the...

check msdb dbo.sysjobs dbo.sysjobsteps dbo.sysjobschedules dbo.sysschedules

1. Why would you put this in a job ?
2. Why don't you just run the Alter in a TSQL jobstep ?

You could try to download the bak file locally ( with e.g. Microsoft Azure Storage Explorer ) and then perform the restore.

• Can you show the result of

  Restore HeaderOnly from url= ... ?

  ?

• Keep in mind you cannot restore backup files of azure SQLDB or Azure Managed...

You could start with this query:

/*
type char(1) Backup type. Can be:
D = Database 
I = Differential database 
L = Log 
F = File or filegroup 
G =Differential...

I haven't encountered issues yet.

In any case, best is to start your preparation using   SQL Server Data Migration Assistant

Regarding your error: Check the choose function in Books online ! It expects an INT for index value !

check out date functions in books online !

With regards to using the "not exists " variant vs the "left join where key is null" : it all about the volume you expect to delete vs the set...

FWIW

Have you tried replacing the "not IN"-lists with temp tables or tablevars ?

Basically you have SQLServer using its query engine in a better way using table objects in stead of...

Using Standard Edition I assume.

AFAIK Std Edtn only supports Basic Availability Groups and has limitations !