The stange thing is, on Windows 10 with SSMS 20.2, this still works.

What is different with Windows 11 ?

Don't !

There must be a reason someone configured it that way.

In SSMS object explorer, rightclick your database name, click "tasks", select "Generate Scripts"

Why did you leave it with version 15.0.2125.1 ? ( that is GDR plus a couple of security updates pior to CU1 !!! )

Current is

November 14, 2024 at 2:52 pm

#4481733

if you want to extract that information from the OS:

# View certificates in the Local Machine's Personal store
Get-ChildItem -Path Cert:\LocalMachine\My

# Get detailed info for a certificate by...

what are the operating systems of both servers ?

if e.g. source is Win2022 and target is Win2003, chances are you may need to add 3DES to the communication protocols used...

Let's see what Elon does within now and a couple of weeks or months.

I fear, technology fears will be fed and strengthend by all abuse of size/scale and the impact...

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, *...