FYI, I broke down and called Microsoft.

They had me walk through the steps and do it again through the tSQL query window instead of the GUI. Evidently, sometimes the...

I'm not sure what a SNAC is. Is a local alias sort of what I described earlier?

I contacted the company that makes it, and they said it was impossible....

I may just be entirely out of luck.

I went to the application server (ROME) and took a look at it's configuration. It's an application called Misys, and it simply...

I have no idea about the syntax 🙁

I changed it to:

ALTER DATABASE Webapp SET PARTNER = N'tcp://agrippa.fchhh.local:5022'

AGRIPPA is the mirror and JERUSALEM is the principle (ATHENS is the witness).

I ran those queries as you wrote them, and I get "Incorrect syntax near 'n'."

:ermm:

I didn't use a query window last time. A friend showed me how to test the endpoint using the ODBC panel in Control Panel.

What I hope to be the last question (and probably the dumbest sounding), how do I issue commands directly like that? I've been using SSMS the whole time.

Yes, I know it does that automatically (so at least that's taken care of).

It seems I won't be able to do this until I can take everything offline first. ...

I'm afraid I don't quite understand what you mean with the retry logic. The witness server has native SQL client running, but it's not the principle database. If...

Yes, there is a lot of activity, and for the life of me, I can't seem to take the DB offline. My guess is the application that is using...

The actual error for the transaction log (I've gotten it on two other db's now too) is:

The mirror database, "UserDefinedDatabase", has insufficient transaction log data to preserve the log backup...

I am feeling utterly defeated by this.

Last night, I started the process from the beginning, just to make sure I did it all correctly.

1) Performed a full backup...

Thanks for that! I added the instance name I was running it from, and it moved to a new error (yay). It's the backups I did, evidentally it...

Todd,

It's Monday, I'm back at work, and dealing with the mirroring again.

Just to make sure I'm starting clean, I've done the following:

Made a new full backup of the primary, and...

I think I'll do that.

Sounds like a dumb question, but how do I remove the endpoints? It appears that the SQL Manager has remembered all settings, even though...