Brilliant, thanks. I've left the sp_help_revlogin SP on both servers in case they failover again in future and something else goes wrong. The cluster was built before I joined the...

Think you've helped solved it! Querying sys.databases showed Log_reuse_wait_desc was set to "Replication". There is a non-working publication/subscription that has been unable to connect to the secondary server for around...

Thanks for the reply. There is no real RTO/RPO strategy at the moment, so I'm trying to understand the complexities of the systems I've inherited before working on that with...