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

Sql Server 2008 mirroring problem

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
Boris_FMPL
Asked:
Boris_FMPL
1 Solution
 
KoreKailasCommented:
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
 
Boris_FMPLAuthor Commented:
Thanks for quick reply,
I found cause - te certificate was expired - I recreated certificate and now is ok.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

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