Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring ( Principle , disconnected) Expand / Collapse
Author
Message
Posted Saturday, May 21, 2011 9:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 9:03 AM
Points: 144, Visits: 640
Hello All,

i have two databases set up as database mirroring on sql server A. connect to SQL SERVER B.

every thing was working fine.
last night we had windows patching and i paused database mirroring on the database.
this morning the database is showing.

( principle , disconnected)

by the way it happened on the names instance,

the default instance has a database mirroring set up too which came back online as synchronized.

but the name instance is showing disconnected.


i have verified that the services are up and running on the mirror server.

Any idea?

thanks in advance
Post #1112899
Posted Saturday, May 21, 2011 11:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:10 AM
Points: 1,155, Visits: 4,624
Did you checked the application log and sql server error log for the both servers?
What is error are you getting?

@SQLSoldier is will help you.He is specialist in database mirroring.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1112915
Posted Sunday, May 22, 2011 8:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 9:03 AM
Points: 144, Visits: 640
thanks for the reply, i was able to solve the issue and puttting it over here for the future if some 1 else gets in to the same problem.

the issue is related to the re-booting after the reboot the principal was not able to connect the server.. based on my research there are 2 steps to solve it.

- re-start ur service which will bring the mirror server to (principal and synchronized state)

if that doesnt work than we have to do the long process.

remove mirroring and config the mirroring again
for this these are the steps to follow.

on the mirror server since the database is set as a mirror database and showing in a restore state; change that to the regular state
for this you have to run the ALTER DATABASE <database name> SET PATNER OFF
this will bring the database in the regular state

now you have to do apply the full backup and all the trans log backups up till the last trans log backup.

i know in the books online it says just full backup and one trans log backup will do but it didnt work in my case. i had to apply full backup and all the avialable trans long backups from the principal database to the mirror database.
make sure to use the NON_ RECOVERY option and replace or overwrite the existing database option.

once that is set than use the mirror wizard and configure the database mirroring.


long process but worked like a charm for me.

thanks for every onces help.
Post #1112996
Posted Monday, May 23, 2011 3:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:10 AM
Points: 1,155, Visits: 4,624
Glad to see this. Thanks for your respond.

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1113218
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse