That is normal as security has become tighter with the lastest updates.

To ommit this extra security for dbatools you can use

<# https://docs.dbatools.io/Set-DbatoolsInsecureConnection.html
Synopsis

Sets the default connection settings to...

Did you check with DBATools ?

ref:

Export-DbaBinaryFile

Import-DbaBinaryFile

I asked Copilot how to overrule an Nhibernate generated query:

To overrule or customize an NHibernate-generated query, you can use native SQL queries or HQL (Hibernate Query Language). Here are...

Of course, splitting the query and using UNION ALL to put it all together may be an option too.

did you switch from 32-bit version to 64-bit version of the software ? ( We're using the 64-bit versions whenever available )

64-bit versions have always been advised to set max-memory-size...

of course, there's also the database's page verify option, that protects page content ...

Anyone who has write auth on the backup file, can manipulate it.

Will it be restorable?

• use checksum as a backup parameter, so SQLServer checks this and prevents a restore of...

btw: if you also want an inventory of all members of db group db_owner in all db, you'll need to provide the account Connect to all db.

use...

probably.

To see the actual db owner of a db, you only need a login.

CREATE LOGIN [test] WITH PASSWORD=N'123Test...........', DEFAULT_DATABASE=[master];

When logged in as that account, the following query...

Did you try:

Select 'Restored' as source, AppUser.UserId, usergroup.Name, AppUser.UserName
from AppUser
INNER JOIN RestoredDatabase.dbo.AppUser_UserGroup 
    ON AppUser.UserId = AppUser_UserGroup.UserId
INNER JOIN RestoredDatabase.dbo.UserGroup 
  ...

Glad you already got a solution.

The flaw / bug in my script was that I hard coded "'production' as source,".

If you remove that "source" column from both queries, you'll get...

Did you try:

Select 'Restored' as source, AppUser.UserId, usergroup.Name, AppUser.UserName
from AppUser
INNER JOIN RestoredDatabase.dbo.AppUser_UserGroup 
    ON AppUser.UserId = AppUser_UserGroup.UserId
INNER JOIN RestoredDatabase.dbo.UserGroup 
    ON...

Can you post the exact error message?

After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was killing...