You don't have "copy_only" enabled as an option on the log backups do you?

This will never mark the log as re-usable.

Inherited very large AOAG setup once where the previous DBA...

You will need to run SSMS in the security context thats running the SSAS services, to trick SSMS and SSAS into thinking your logged in as the service account.

Whats the output of this code snippet?


select value_in_use from sys.configurations where name = 'backup compression default'


If it's 1 the default setting is to compress...

Perfectly acceptable depending on requirements.

Read up on both of the settings as each isolation level does different things

https://blog.sqlauthority.com/2015/07/03/sql-server-difference-between-read-committed-snapshot-and-snapshot-isolation-level/

Are you using the SSIS catalog (project deployment) or are you doing the old FileSystem / MSDB (package deployment) methods to deploy your SSIS solutions?

If the new version,...

Personally I would create the cluster at the start, all be it a 1 node cluster and enable the AOAG feature, as doing that later needs a restart of the...

Bond