Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sql Server 2008 mirroring problem

Posted on 2010-08-18
2
Medium Priority
?
302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Expert Comment

by:KoreKailas
ID: 33462781
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
ID: 33463329
Thanks for quick reply,
I found cause - te certificate was expired - I recreated certificate and now is ok.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

609 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