Database suspect mode

Question

Post reply

Database suspect mode

SQL Galaxy

One Orange Chip

Points: 29472
More actions
April 15, 2019 at 12:25 pm

#3372329

Database suspect mode but i can't remove mirror or set emergency mode now, due to database configured mirroring.
How can we remove mirror in principal server? pl. suggest
Thanks
April 25, 2019 at 8:00 am

This was removed by the editor as SPAM
April 25, 2019 at 8:04 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 1

ALTER DATABASE [DBNAME] SET EMERGENCY

Error Messages:

Msg 1468, Level 16, State 1, Line 1

The operation cannot be performed on database "DBNAME" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Need to remove mirroring in database suspect mode

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 2

Not sure if this will work, but from the secondary, try setting the partner off.

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

Thanks Steve for your reply..

I tried this option already for PARTNER OFF at mirror server. but not able to bring database in EMERGENCY mode in Principal server.

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 4

I have no idea and can't see anything on this posted. If this is a production server, call Microsoft support.