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?

Ah

#Context

Do you have the link to the "dup post"?

If you cannot switch the sql server service to use a domain account, you'll have to grant the file share to the computer account.

I always add such attributes to the action part of the ADD EVENT

CREATE EVENT SESSION [DBA_purpose] ON SERVER
ADD EVENT sqlserver.database_file_size_change (
ACTION ( sqlserver.client_app_name, 
 sqlserver.client_hostname, 
 sqlserver.database_name,...

A number of tools already use DRI information (FK) to build their internal data model. (entity framework etc...)

But if the current evolution of AI is the drive to - finally...

It's not the sqlagent service account, but the sqlserver service account that needs the auth to get to the file share !!

Don't just change the DBLevel !

Coordinate date and time of your action to the given software teams, so in case they should get alarms, they know about this all.

What is the actual error code you get when executing the sql statement ?

The service account of the target instance needs read auth on the backup share ( and location...

I read you've already prepared it using DMA.

You'll have to address your devs or software vendor(s) to have them test their apps against your target db level.

I would aim to...