Browse by Tags

Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"

Published 12 November 7 3:23 AM | SSQA.net

Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system...

Filed under: sql server, security, bug, database mirroring, error log, 2005, stored procedure, monitoring, hyphen, connect site

SQL Server Database Mirroring error with TCP port numbers, firewall involvement

Published 13 September 7 10:35 AM | SSQA.net

Lately we have been getting complaints that database mirroring setup on few of our client's site were failing with TCP related errors. For more information these sites are involved within the firewall setup and active directory too. Initial workaround...

Filed under: sql server, database mirroring, error log, tcp, network, firewall, wan, failed, endpoint, setup