check the sql server errorlog file

You've got the correct clustered index on CDPOS, except perhaps that it's not unique.  If adding CHANGENR to the clus index will make it UNIQUE, you should do that.

Either...

The first thing I would check is the amount of disk space available.

Also, I would rarely use RESTORE...WITH REPLACE. I would normally restore to something like MyDb202405301201 and then...

Your script seems to be what it needs to be.

Which version number is your target sqlserver instance ? ( did you apply the (near) latest cumulatieve updates

ref: SQL Server...

Thank you for the feedback 🙂

If you only take full and diff backups, I assume your databases are in simple recovery model ( or your db log file(s) will keep on growing after the first...

You need to grant the sql server service account auth to get to the new backup file location/share

IMHO AzureMI have been brought to life to have people be more keen to (try to) migrate and land on an environment they are familiar with.

• DBMail needs specific attantion

...

Keep in mind you windowing functions work on the result set itself !

Since you want to have time series reporting, you need to make sure your rows cover occurrences for...

After errorlog investigation:

first thing to do is to take another LOG backup ( if db recovery model <> simple )

Then restore from full backup and add the needed DIFF and...

Did you investigate Filestream or FileTable options ?

Backup only takes the pages as is and calculates a checksum based on that data.

Checkdb actually checks it all.

on top of that:  What's the page_verify option set for your...

You need to specify to support unsecured connections 🙁

I hope your applications do not use table hints to force the use of a given index.

Also doublecheck the indexes are enabled !

( maybe disabled for 99% of...

Does sys.index_resumable_operations hold data?