Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Move Principal to a new server but leaving the Mirror where it is Expand / Collapse
Author
Message
Posted Wednesday, October 9, 2013 9:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 10, 2015 8:28 PM
Points: 1, Visits: 344
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?

Thanks
Judith
This is my first post.
Post #1503361
Posted Wednesday, October 9, 2013 10:13 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 21, 2016 10:46 PM
Points: 128, Visits: 601
Mirroring should be newly configured between the servers again.

Cheers,
- Win
"Dont Judge a Book by its Cover"
Post #1503366
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse