If InfoSec already has an issue with replication because you are going from Prod to Non-Prod, then using backup/restore is also going to be an issue.  Anything that allows...

I have a SQL database of 2 TB running on production. There is a need to refresh this database on Q environment on a daily basis. Cannot implement SQL...

Comparing yourself to an even bigger asshole doesn't lessen the fact that you're an asshole.  In fact, it confirms just how much of an asshole you are. 😉

Are you absolutely sure that the drive path and the UNC are actually pointing to the same directory?  I HAVE seen people get confused on such issues before.

You can explain things without being such an absolute condescending asshole, Joe!

Crud... I missed that detail because I was only...

As yet another side bar, unless you have a REALLY good reason to move to 2022, I'm here to tell you that, compared to 2017, 2022 is about 30% slower...

Duplicate post deleted.

As a bit of a sidebar, I'd change the YrMo and YrMo2 columns to a DATE datatype.  It's 1 byte less than an INT and a whole lot more useful...

You bet, Rod.  Thank you for the feedback.

As a bit of a sidebar, I have a now fairly old laptop that I got a couple of year...

BTW... thank you for the heads up on the UK postal thing and the really incorrect premise that the computer is right until you can prove it's not.  Both are...

Sorry Jeff  for the  inconvenience. kindly see the below code

INSERT INTO [dbo].[10_SOR_MB]
           ([item_id]
   ...

Search in Duck-Duck-Go for "installation requirements for SQL Server Developer Edition" leads us to a link for the following...

https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019

That has links on it for other versions.

Then, this is fairly easy even in a 24/7 environment (although you didn't list the CREATE TABLEs in full so not 100% sure)

To be sure, the first thing that I'd...

The article cited "This also coincided with a (an unrelated) law that changed saying computer systems were presumed correct and anyone accused of a crime had to prove the computer...