Welcome to SqlServer-QA.net Sign in | Join | Help

High Availability (SSQA.net)

Importance of Service Delivery within your environment, know more here.

Browse by Tags

All Tags » error log   (RSS)
Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"
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. Read More...
SQL Server Database Mirroring error with TCP port numbers, firewall involvement
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 Read More...