We are running SQL 2005 Server Standard Edition. We need to move some large mirrored databases to a new server with minimum downtime. I need to move the current principal on server A to a new principal on server C while leaving mirroring where it is on server B. Is this possible?
I can restore the current principal to the new principal, but get stuck when it comes to starting up mirroring again. Can someone tell me how to do this?
This is my first post.