Was hoping that I would find this documented somewhere, but I've searched and searched. Finally asking the question myself:
I have SQL Server 2008 R2 in a HA setup (primary/mirror/witness)
I want to move the mirror and witness servers to different hardware from what they're currently on.
It's only 1 db and about 20GB in size, it uses SQL authentication for the db (not Windows auth) and the Windows SQL service will run with the same domain user on all nodes.
I assume I start by installing SQL Server on the new nodes, and adding the endpoints to each instance.
From there would I just remove mirroring from the primary instance and re-create mirroring, adding the new nodes? Would I need to restore from a backup on the new mirror instance?
Hopefully someone can lay out the steps involved, thank you.