Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, July 24, 2014 10:49 PM
Points: 1, Visits: 273
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: Thursday, July 24, 2014 2:10 AM
Points: 109, Visits: 460
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