Database suspect mode

  • SQL Galaxy

    One Orange Chip

    Points: 29228

    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

  • SQL Galaxy

    One Orange Chip

    Points: 29228

     

    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: 714633

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

  • SQL Galaxy

    One Orange Chip

    Points: 29228

    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: 714633

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

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

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

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