did you check for "Cross database ownership chaining" ?

Ref 2: "Understanding Cross Database Ownership Chaining in SQL Server"

I want to restore the DBs to another MI in regular intervals as use to do in traditional SQL. Please suggest how to make it possible to schedule automated...

The only thing you can do - if you  really want your own backup files - is to remove TDE

have a look at "Removing TDE from a Database: Level...

You can, but only "copy_only" backups.

With PAAS solutions (like Azure SQLMI or azure sqldb) you tipically don't have to worry about backups after you have selected (and accepted $$) your...

A pleasure. Let me know...

IT DEPENDS !

Database mirroring is not dead yet! ( Such a shame Microsoft uses that terminology now in its cloud context )

It still works and in some cases outperforms AG's...

check "sql-server-diagnostic-information-queries-detailed-day-17" Query #40!

What is the actual error message ?

Do you have monitoring for succeeded and failed connections ( in this case especially on S2 ) ?

When using a SQLUser, how did you...

Have a look at :

• "Service Broker Part 1: Service Broker Basics"
• "Adventures With Service Broker"
• "How to troubleshoot Service Broker problems"
• "Troubleshooting Service Broker (SSB)"...

Going backward over version(s) is always a hard time.

As you've figured out, the only way is a scripting and data migration solution.

On the other hand, since sqlexpress is free, why...

Thank you for the cautions, Grant.

I always develop xEvents related stuff on my local box, then on a dev box, then on a QA box and only then ....

As you...

"RETURN EXECUTE ..." ? ( I never used this consturction )

Did you verify the database backup at the source server?

Nowadays we experience more and more "shadow IT". Meaning people at the business side gaining knowledge about some "new" programming tool / reporting tool / skills driven language / ......

Check sys.foreign_keys ( did not read the full Q )

Indeed, some tools can suggest logical relationships. Mostly based on column name and data type.

However, that must still be double...