please post the actual SQLServer @@version information?

No wonder most of us avoid linked server usage whenever possible

Is this a dedicated sql server machine?

what is you max server memory set to?

Is CDC active on the database in the backup file ?

I started backup right after a server down\up ...

The backup for the past month was working fine... just started this issue a few days ago.

I'm going to try a...

Are your applications using Snapshot Isolation level ? ( also have a look at "tempdb tutorial"

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