September 1, 2009 at 12:57 am
Hi All,
I have two three servers [Master-Mirror-Witness] for Database Mirroring. Two weeks ago certificates expired and i restarted servers. After Openning, Mirroring fall down,
All Database status are Disconnected- Recovery.
I setup new certificates, and change mirroring directions to new certfificates.
How could i activate mirroring?
Regards.
September 1, 2009 at 4:17 am
I think you should alter one db to primary
Check "Pausing and Resuming Database Mirroring " in BOL !
Check "Database Mirroring How-to Topics " in BOL !
from BOL topic "How to: Resume a Database Mirroring Session (Transact-SQL) "
To resume a database mirroring session
Connect to either partner.
Issue the following Transact-SQL statement:
ALTER DATABASE SET PARTNER RESUME
where is the mirrored database whose session you want to resume.
Note:
Resuming database mirroring places the mirror database in the SYNCHRONIZING state. If the safety level is FULL, the mirror catches up with the principal and the mirror database enters the SYNCHRONIZED state. At this point, failover becomes possible. If the witness is present and ON, automatic failover is possible. In the absence of a witness, manual failover is possible.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply