As there is no witess available, so when resumes the mirrored database by
ALTER DATABASE <database_name> SET PARTNER RESUME;
does not resumes the mirroring. Resume button is also disabled. I don't get any error. What is the checkpoint?
-
1what is principal and mirror database status? – Rajesh Ranjan Mar 23 '18 at 6:41
-
hope it will help you out social.msdn.microsoft.com/Forums/sqlserver/en-US/…. – Rajesh Ranjan Mar 23 '18 at 6:45
-
I have found the error, Master Server and Mirror has different SQL Server Version. – Pankaj Kumar Mar 23 '18 at 6:48
-
1I think you upgraded mirror server. right? if yes then SQL Server does not support mirroring across different version & edition. You'll have to upgrade principal server to keep it working. – Rajesh Ranjan Mar 23 '18 at 6:52
Did you also check on the SQL errors? What does it says...?
One thing you can try is to restart your endpoint mirroring on both the primary and secondary instance to see if it helps.
(Stop the endpoint mirroring first)
ALTER ENDPOINT STATE=STOPPED
(Then start it back up)
ALTER ENDPOINT STATE=STARTED
