• Let me apologize ahead of time for asking a lot of questions but I definitely want to try to recover as much as possible and of course to do this all correctly.

    Breaking the mirror: Run the alter database 'database name' partner off command?

    Restablish the mirror: same as above with the partner on command?

    I should mention the mirror side is displaying: Mirror Synchronizing\Restoring

    Also, I have another database that just is sitting on the mirror server that simply says "In Recovery" and nothing else. I ran the partner off command on there but cancelled after about 25min so my concern is the possibility that the command won't work on the principal.

    But if it does, then after reestablishing the mirror I should be able to have the mirror in a Mirror Synchronized\Restoring and should be able to back that up and then restore to the principal?

    Thank you very much for your input by the way!