Start by referencing this KB article, also use DMA to highlight issues when moving from one sql platform\version to another

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16#differences-between-compatibility-levels

The below code works for backup files only from local drives.

When replaced with a network path the code just runs through but does not restore any dbs.

SET @backup_path='\\ABCD\E$\BackupsTest\' ;...

I also spotted that the managed service offsite backup vendor that is in use had changed their scheduling slightly in the last week, and that their backup schedule was...

Bear in mind that the user who owns the database maps in via the dbo database user and can do all that members of db_owner role can do

The databases are using TDE or column level encryption?

also run the following and supply the query results

select name, is_master_key_encrypted_by_server
from sys.databases
where name='ssisdb'

have you created a security policy, cant see code example below, might be worth reading this before you go any further

https://learn.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver16

need more info on the source A database, anything obvious in the logs?

Here are some articles on 824 and 825 error that may help

824 err

825 err

We're a hosting company but the end-user/customer has a DBA who manages these servers so I'll get him to query the sys.credentials catalog for any backup to URL related...

Recommend you try again and go through in detail following the relevant sections

Hi Perry,

Thanks for the reply. I'm not much of a SQL guy so I'm not sure how to go about "query the sys.credentials catalog for any backup to URL...

Which guide you use

Seems to be steps missing there.

have you confirmed you can open the master key on the source and the destination

The only custom CDC alerting I have done for sql agent jobs is around AG failover what parameters are you currently targeting

important to understand the encryption hierarchy, each time a project\package is created and...

• This reply was modified 7 months, 1 week ago by  Perry Whittle.