Browse by Tags

SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

Published 12 May 8 4:25 AM | SSQA.net

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...

Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout

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

FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005

Published 12 September 7 12:46 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Changes in the publisher database are not replicated to the subscribers in a transactional...

Filed under: sql server, replication, kba, database mirroring, publisher, transactional, 2005