• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

SQL 2008 DB Mirroring question

Hello there,

We had to break the Mirroring and one of the upgrade on the DB went wrong. What is the best practice approach to restore the mirroring back?
I have three servers in the quorum - Principal. Mirror and Witness.

Please advise.

Thanks and Regards
0
goprasad
Asked:
goprasad
1 Solution
 
goprasadAuthor Commented:
Any one who can help?
0
 
Ramesh Babu VavillaCommented:
compare the data between 2 database and restore the best one
redgate database compare is the best option
0
 
VENKAT KOKULLASQL Server DBACommented:
Please go through the attached doc it will guide you in and out completly guide about the mirrioring..
Mirroring.docx
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now