The alert for ‘time behind’ has been raised. The current value of ‘xyz’ surpasses the threshold ‘abc’.

This is the strange error message that I encountered from a mirroring principal server on which an alert is set to report to DBA team if error number “32040” is detected.  The official Microsoft description of this error message can be found here at Microsoft’s website. And usually this error is reported only when unsent transactions are piling up at the principal box. However, the mirroring monitor showed perfect 0KB of “unsent log” and 00:00:00 of “oldest unsent transactions”.

To resolve this issue, I used the “pause and restart mirroring” approach that somebody mentioned here at SQLServerCentral’s forum. The exact scripts are as follows:

ALTER DATABASE [DBNAME] SET PARTNER SUSPEND
GO
ALTER DATABASE [DBNAME] SET PARTNER RESUME
GO
Advertisements

About Nick Xu

Not a DBA anymore
This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s