May 21, 2011 at 9:54 am
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
May 21, 2011 at 11:25 am
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
https://www.sqlserverblogforum.com/
May 22, 2011 at 8:14 am
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.
May 23, 2011 at 3:57 am
Glad to see this. Thanks for your respond.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 1, 2017 at 4:24 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply