May 5, 2020 at 9:58 am
So I've been off for a few weeks & the stand in has messed up my mirroring on a couple of dbs. He's not here & I don't know what he's done.
I want to delete the mirror db & re-mirror. I can't drop the db on the mirror as it thinks it's mirroring. I can't ALTER DB x SET PARTNER OFF on either. I can't start mirroring. All produce expected errors.
The only 2 things I have left to try are:
Any other ideas / suggestions?
This is live & I have no test system.
May 5, 2020 at 1:02 pm
Update - restarted the SQL server on the mirror & the issue resolved itself. Meta data was amended & I was able to drop the databases. Not ideal & unsure how it occurred but it worked.
May 5, 2020 at 4:37 pm
Thanks for the update
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply