SQL Server 2008 R2 - Moving nodes in mirrored environment 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.
You are correct..


Install SQL Server on the new nodes
Use SP_HELP_REVLOGIN to copy the user account to the secondary node
Take a full backup and a single log backup of the primary server and restore on the secondary with no_recovery
Break the mirror and remove the secondaries from the primary server
Create the endpoints with TSQL or use the Mirroring wizard to configure them and endpoint security
start mirroring