November 24, 2012 at 2:33 am
Dear,
There was some problems in my principal server and sql server get corrupted. I have also configured replication in my principal server.
Now in mirror server, I see the mirror database like myDB (Mirror, Disconnected/ In Recovery).
What should I do to keep mirroring live?
Please help me to sort out the problem.
Regards,
Akbar
November 24, 2012 at 3:12 am
Can you provide more details around your mirror setup?
What do you mean corrupted?
What are you doing to get the principal back online?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2012 at 5:00 am
I installed three instances of sql server in my PC. One was default instance and others were named. I configured default instance as "Principal" and one of the named instances was "Mirror" and another was "Witness".
Then I configured mirroring with High safety with automatic failover option. After that I configured replication on Principal.
Now I shut down my PC and started SSMS, tried to login to Principal but failed. An error message is displayed like "A Network-related or instance-specific error occurred while establishing a connection to SQL Server. The Server was not found or was not accessible."
So I removed default instance and again installed default instance. Now I can login to default instance.
That's all about.
Thanks for your time.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply