Backups look good to me;

LastFullBackup                  LastDifferential                 LastLog
2017-08-17 17:34:19.000    2017-08-17 22:30:35.000    2017-08-18 14:42:06.000

Thanks for replying! The log backups are definitely not copy-only but it's a good suggestion. I'm just reading about fn_dump_dblog() now because I haven't done that before. Will be back...

If you don't want to use log shipping any more, remove it and set up some transaction log backups.

In addition to the above (don't get too hung up on shrinking the log; if it needs to grow, it needs to grow), what does the following return?

select...

That's what I thought, but he says that doesn't work...

What's the error message when you use the full hostname\instancename?

Have you tried using fully qualified domain names? Are your clusters in different domains?

Are you putting in the full instance name (e.g. HOSTNAME\MSSQLCLUSTER) where it says primary_server_instance and secondary_server_instance, or just MSSQLCLUSTER?

            
August 8, 2017 at 6:44 am
            
#1954451

            
            
                                                
        

I think a bit of Googling would go a long way here, but a Distributed Availability Group can be thought of as an Availability Group of Availability Groups. They can...

Possibly something to do with marine science/oceanography, or volcanology. Not sure.

You're welcome, by the way ;).

Yes; if you use Windows Authentication you don't have issues with that.