Solved

Sql Server 2008 mirroring problem

Posted on 2010-08-18
2
282 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

726 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