Home Forums SQL Server 2008 SQL Server 2008 High Availability Adding a new article to existing publication(That subscribers have not been generated based on snapshot) in SQL SERVER 2008 R2 RE: Adding a new article to existing publication(That subscribers have not been generated based on snapshot) in SQL SERVER 2008 R2

  • I was thinking by having the failover partner setup in connection string all the jobs should continue to work, but this did not happen.

    Mirroring protects the server and the database from failing, not the client. How the client behaves depends upon the client (even when the failover partner is configured correctly). The errors a client raises should be diagnostic.

    From BOL http://msdn.microsoft.com/en-us/library/ms175484.aspx

    If the specified server instance is available and is the current principal server instance, the connection attempt typically succeeds.

    [...]

    If that attempt does not work, the data access provider tries the failover partner name, if available. If either partner name correctly identifies the current principal server, the data access provider normally succeeds in opening the initial connection. On completing this connection, the data access provider downloads the server instance name of the current mirror server. This name is stored in the cache as the failover partner name, overwriting the client-supplied failover partner name, if any. Thereafter, the .NET Framework Data Provider for SQL Server does not update the failover partner name. In contrast, SQL Server Native Client updates the cache whenever a subsequent connection or connection reset returns a different partner name.

    What data provider(s) is/are the SSIS packages using? Could the "Thereafter" sentence explain the errors I imagine the client was raising? What complete & verbatim errors were being raised?