Sample Header Ad - 728x90

SQL Mirroring Witness server Corrupted

1 vote
1 answer
185 views
The witness server on my environment is corrupted and the mirrored database failed over to the secondary server. I removed database from Principal server, hoping that I can set up mirroring between the Mirror and Principal. So I backed up the database on Mirror, and restored it on the Principal; Configured mirroring on the Mirror and when I click start mirroring I got the following error message > Alter failed for the database xxx , An exception occurred while > executing a Transact SQL Statement or Batch.. Database 'xxx' is not > configured for database mirroring. Error 1416 I am guessing the error happened as I didn't remove the previous mirror configuration. How can I remove my previous mirror config and setup a mirroring between these. when i execute this SELECT role_desc, state_desc FROM sys.database_mirroring_endpoints results PARTNER STARTED
Asked by user245321 (31 rep)
Jul 15, 2022, 05:35 PM
Last activity: Jul 8, 2025, 03:06 PM