I had this situation when my production server was restarted .
To fix this issue , I have gone through the error log to find out the exact reason and identified that connection between principal and mirror is not established properly .Mirrored database with a big logfile and a server restart caused the " In Recovery State " of the mirrored database .
To fix this error I have to restart the database mirroring end point.
Step1 : Stop the Endpoint
Alter EndPoint < End Point Name > State=STOPPED
Step2 : Start the Endpoint.
Alter EndPoint < End Point Name > State=STOPPED
To fix this issue , I have gone through the error log to find out the exact reason and identified that connection between principal and mirror is not established properly .Mirrored database with a big logfile and a server restart caused the " In Recovery State " of the mirrored database .
To fix this error I have to restart the database mirroring end point.
Step1 : Stop the Endpoint
Alter EndPoint < End Point Name > State=STOPPED
Step2 : Start the Endpoint.
Alter EndPoint < End Point Name > State=STOPPED
No comments:
Post a Comment