It will be really cold in Iceland in February.

Copy-only backups only really matter if you also take differential backups. If you don't, it won't make a difference. Full backups don't "break the log chain", they only reset the...

What specifically is your log_reuse_wait_desc for that database?

So, what do we all think of today's SQL 2019 announcement? I'm sure many of you were already aware behind the scenes, and they did also accidentally leak the news...

Ok, so you're only permissioned as a sysadmin, then (through membership of that group). That's why.

What do you get if you run xp_logininfo [domain\yourpersonalaccount], @option = 'all' ?

As long as you restore the secondary database with norecovery and then add them to the AG with JOIN_ONLY it should be fine. Try it with a smaller DB first.

In Management Studio, go to the AG and right-click on it, then select Show Dashboard (make sure you're on the Primary replica). Then at top right there's an option to...

Select name, log_reuse_wait_desc from sys.databases will give you the reason the transaction log is not being truncated. Also full backups do not truncate the transaction log, just in case those...

No shared disks with Availability Groups assuming you just have two standalone SQL instances.

Yep, that's an issue with SSMS 20167 I've just tried it. If you use SSMS 2016 it should work.

SQL Server can be very memory-hungry. This is the normal state of affairs. Check that you have configured your Max Server Memory setting away from the default.