Mirroring issues
I recently came across this error message:
the remote mirroring partner for
database *********, encountered error 5149, status 1, severity 25. Database
mirroring has been suspended. Resolve
the error on the remote server and resume mirroring, or remove mirroring and
re-establish the mirror server instance.
I hate undocumented
error messages so I thought I’d add my resolution.
It appears that the
log file on the mirror site was unable to extend the log file. The network
connection dropped for a time and the build up of unsent transactions caused the
primary log file to extend, when the network connection was re-established the
mirrored logfile was unable to exend by the same amount. The moral of the story is to always allow
enough space on both the primary and mirrored server for times when the network
drops!