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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityAs 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?
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