Browse Site by Tags - MSMVPS.COM

FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you start a database mirroring...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 02-04-2008
Filed under: sql server, services, kba, database mirroring, failover, endpoint, port

FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 12-17-2007
Filed under: sql server, services, kba, alert, database mirroring, principal, restart, debug

FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Transactions that are being committed on the principal...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-26-2007
Filed under: sql server, kba, database mirroring, principal, transactions, mirror, failover

FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you use SQL Native Client to...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-21-2007
Filed under: sql server, instance, kba, connections, database mirroring, principal, native

FIX: Error message when you run a maintenance plan that contains a Back Up Database task in Microsoft SQL Server 2005 Service Pack 2: "0x80004003: Object reference not set to an instance of an object"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you run a maintenance plan that...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-19-2007
Filed under: sql server, kba, service pack2, object, database mirroring, backups, exception

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

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 replication if the publisher database...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-12-2007
Filed under: sql server, replication, kba, database mirroring, publisher, transactional, 2005

How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications How to install service packs and hotfixes on an instance...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-08-2007
Filed under: sql server, kba, database mirroring, service pack, configuration

The following KBA pages were recently modified - SQL Server 2005 webcasts

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Support WebCast: How to use the DataReader Source and the OLE DB Source objects in SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-27-2007
Filed under: sql server, webcast, kba, oledb, database mirroring, backups, overview, datareader