none
sp_dbmmonitorupdate is failing with internal error RRS feed

  • Question

  • In one of the server that has mirrored database, I am getting this error.

    Msg 32038, Level 16, State 3, Procedure sp_dbmmonitorupdate, Line 180
    An internal error has occurred in the database mirroring monitor.

    Can't find any documentation on what is the issue. Any ideas?
    Sunday, September 23, 2007 1:59 PM

All replies

  • I found the problem, one of the mirrored database was in disconnected state, I ran

    ALTER ENDPOINT endpointname
    STATE = STARTED
    AS TCP (LISTENER_PORT = 5022)
    FOR database_mirroring (ROLE = ALL);
    GO

    this made it synchronized, the sp_dbmmonitorupdate procedure is running fine now.
    Sunday, September 23, 2007 2:13 PM