Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Mirroring ( Principle , disconnected)


Database Mirroring ( Principle , disconnected)

Author
Message
qur7
qur7
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 816
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
muthukkumaran Kaliyamoorthy
muthukkumaran Kaliyamoorthy
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1225 Visits: 4840
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

qur7
qur7
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 816
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.
muthukkumaran Kaliyamoorthy
muthukkumaran Kaliyamoorthy
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1225 Visits: 4840
Glad to see this. Thanks for your respond.

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search