My advice - reach out to your licensing contact as they will be able to help you more than a random forum.

But according to Microsoft:

Client access licenses (CALs) are required...

I think log shipping should work. Found a blog post where someone did that with a 60TB database:

https://johnsterrett.com/2015/08/18/adding-a-vldb-database-to-an-sql-server-availability-group-in-60-seconds/

And they had basically no downtime!

I've not done anything that big before, but there are tools that make failovers nice and easy without the need for AG's. We use DxEnterprise for our failover and it...

As a thought - any way you can reduce the database size? Is there some data you could archive to get it to a more manageable size or is all...

My opinion, AI is great for handing tasks that are slow and error-prone by users. Hand me a 1 GB log file and ask me to find the problem OR...

One way to handle removing linked servers is to handle...

I'd start by following the Microsoft advice for troubleshooting this - https://learn.microsoft.com/en-us/troubleshoot/sql/tools/troubleshoot-database-mail-issues

If that doesn't help, then you may want to check your spam folder or outlook rules that may be...

I do agree that in place is not the best way to go, but sometimes it is the best of a bad situation. The way my environment is set up,...

Mistakes happen - it's how we learn. Plus, systems and/or processes and/or policies should be set up to minimize the chance of mistakes. If a big mistake happens, that means...

My opinion, upgrading is pretty safe. If you are concerned, set the compatibility level to 170 150 to keep your databases working like 2019 and without any 2022 features.

I'm slowly...

• This reply was modified 2 months ago by Mr. Brian Gale.

It sounds like a pretty big ask for a free forum to me, but my advice is you track whatever information you feel is relevant. There is data captured by...

I give it -1 for suggesting a trigger.  My rules with triggers is they can only be used if there is no other way. Put the stock update in...

I'm sure there are a TON of these types of experiences. This and DBA's trying to fix issues that don't really exist. Pinal Dave had a good article recently about...

It is still not working, I tried something similar, I think the issue is that @Period is an integer and @FiveYearAgo is not so if I do the where...

• This reply was modified 2 months ago by Mr. Brian Gale.
• This reply was modified 2 months ago by Mr. Brian Gale.

That is always a fun thing to find and a fun thing to fix. Loops and row based logic are performance killers for SQL and unfortunately, I don't think any...