March 6, 2007 at 9:32 am
Has anyone else experienced failures in the SQL 2005 Job--"Database Mirroring Monitor Job"?
This (built-in) job has been running reliably every minute, but after our Systems group applied some updates to the 2003 Server, the job continually fails with the error message 32038--"An internal error has occurrred in the database mirroring monitor".
The updates included KB931836, the daylight savings revision, as well as these security updates:
KB926436
KB928255
KB918118
KB924667
Luckily, the mirroring itself is working fine. But I'd like to know how to get this monitoring job back on track.
TIA
Elliott
March 6, 2007 at 3:49 pm
Check this out...
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1151987&SiteID=17
MohammedU
Microsoft SQL Server MVP
March 6, 2007 at 4:21 pm
Thanks.
I checked it out. Same error message, but apparently a different problem. My mirroring is performing fine. It's only the Mirroring Monitor Job that is failing ("internal error"), and the logs aren't telling me anything about it.
Elliott
March 13, 2007 at 4:58 pm
Update for general interest.
The Job was failing because of a single test database which had been set up as a mirrored database, but became orphaned when the partner server was renamed.
It was not possible to drop or delete this test database until the command
"Alter database <mydatabase> Set Partner Off" was issued. That command was followed by "RESTORE database <mydatabase> with Recovery"
This finally unblocked the mirror status of the orphan database and allowed the Job to run normally.
Elliott
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply