online? No way !

Keep in mind you have to put the database offline and only then you can start moving its files to...

Just my 2ct: did you try to checkpoint all databases before running the backup ?

 

btw: We mostly produce local backup files and only copy those afterward to a safe zone...

Interviewing for open position...

My boss: Rate your SQL skills & knowledge on a scale of 1 to 10.

Interviewee: 7 or 8

Me: Let's talk about backups and restores.

Interviewee: I have...

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