Dear Expert, I have 2 database servers using mirroring without witness server. Unluckily, at the midnight, power supply to server room is off, UPS cannot work well, so my 2 servers is power off suddenly. After power on, i check my primary server database is in suspect status, the secondary is in recovery. So i try to recover primary as some tip on the net but it said the mirroring is currently active. I try to run SET PARTNER OFF but unsuccessful. The secondary i try to run SET PARTNER OFF but i get the same result. And it said it get error in Transaction Log, so i cannot recover it. Please help me to solve this problem.