Apparently there are some extra certificate steps to be taken care of and instance configuration

ref: "How to set and use encrypted SQL Server connections"

Test it - TEST IT -...

hmmm ... you are wright.

I never payed notice to those connections ( assuming they are encrypted due to the endpoint encryption setting, but apparently only the endpoint to endpoint conversation...

Modify your DB mirroring endpoints to force encryption ! ( encryption = required )

Check Create Endpoint

Just get a bigger truck may get this thing done $$$$

Did you validate and test other options for your single table ( 476GB ) ?

How much of that data is...

Your subquery does not make sense as it is not related to the from clause of your query.

(and because it performs the same query as your from clause, it will...

Just to be clear: A tail log serves the target database at the target server of your restore.  ( so in case you need to restore that one back to...

Do not perform a Tail log backup if you just need a transaction log backup !!

A tail-log backups only purpose is that you can restore the original database as it...

Did you actually prefix the correct master database ?

In that case you might as well perform a "union all"

/* contained AG master db */
SELECT 'AG1_master' SourceMaster, *...

So you connect to one of the nodes of the Windows cluster hosting the Contained AG ?

( I don't know if access to master db is blocked when connecting to...

• This reply was modified 1 years, 6 months ago by Johan Bijnens.

Enable "auto close" for that database and monitor the sql server errorlog to see when it is being brought online.

ALTER DATABASE [Yourdb] SET AUTO_CLOSE ON WITH NO_WAIT...

I first prepared both stand alone instances.

Then I restored the needed db on one instance, configured the needed sql accounts ( using dbatools Copy-DbaUser ) and sqlagent jobs (...

1. Your database needs to reside in a non-simple recovery model. ( preferable full recovery model )

   You need at least create one FULL backup ( to actually activate the log...

did you try casting "value" to a numerical data type ?

e.g.

...
SUM(CASE WHEN [Metric] IN (...)
THEN cast([Value] as decimal(18,2)) END) AS [...],
...

Launch a profiler trace to see what is going on

FWIW :

Scientists are currently busy recreating tissues or animals that have been extinct for millions of years.

Perhaps that will be the fate for relational DBA and this phase will occur...