MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

Sign in | Help

All Tags » Security » sql server » database mirroring (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

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. On the system with SQL 2005 Service pack2 when...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 11-12-2007
Filed under: sql server, security, bug, database mirroring, error log, 2005, stored procedure, monitoring, hyphen, connect site
Database Mirroring: Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

The above error is quite common within the database mirroring setup, you could get to see. The intial workaround for this error will be to check whether any network issues are causing this error when the failover is intiated from a Primary server to the Mirror server. By default for the Database Mirroring...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-12-2007
Filed under: sql server, high availability, security, error, database mirroring, service account, 1418, ports

Page 1 of 1 (2 items)

Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems