Monthly Archives: September 2013

Workaround to Register an Instance Out of Your Domain in Central Management Server

It sucks that Central Management Server (CMS) doesn’t support registering an instance by SQL Server authentication (and unfortunately in very DBA’s inventory, there are always a few servers that are out your normal domain but you still have to manage). … Continue reading

Posted in Database Connection, SQL Server | Tagged , , | 2 Comments

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 … Continue reading

Posted in SQL Server | Leave a comment