Solved

Sql Server 2008 mirroring problem

Posted on 2010-08-18
2
247 Views
Last Modified: 2012-05-10
Hi

Some time ago I configured mirroring on several databases (between two servers Win 2003, Sql 2008)
Everything worked fine until now, on all databases I've got status Principal disconected / Mirror disconected). Both servers are up and running. There are only enabled buttons  "Remove mirroring", "Configure security" and "Refresh" on mirroring properties.
How can I connect them again?

Regards
0
Comment
Question by:Boris_FMPL
2 Comments
 

Expert Comment

by:KoreKailas
Comment Utility
you can run below command to resume the mirroring on any server database (Principal/Mirror)

ALTER DATABASE <database_name> SET PARTNER RESUME
ALTER DATABASE <database_name> SET PARTNER RESUME

Open in new window

0
 

Accepted Solution

by:
Boris_FMPL earned 0 total points
Comment Utility
Thanks for quick reply,
I found cause - te certificate was expired - I recreated certificate and now is ok.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now