July 20, 2009 at 1:29 pm
Lets say we have mirroring setup with automatic failover. So, we have a Principal (ServerA), a Mirror (ServerB), and a Witness (ServerW). Witness monitors the princiapl and if there is an issue, brings the mirror online.
Now, for the actual question..... from an application perspective, unless the connection is being made via SNAC or a connection string that specifies the mirror server name, the application will cease to function in the even of a mirror failover as the principal and mirror have different instance names. Correct? there is no virtual server name maintained in this config like there is in clustering?
TIA!
Paul
July 20, 2009 at 2:24 pm
If the first connection is sucessful and you are using the .net platform to connect then the connection string will automatically pick up the mirror instance. Here is the article from microsoft on connecting clients to mirrored databases.
http://msdn.microsoft.com/en-us/library/ms366348.aspx
** This is for SQL 2008.
July 21, 2009 at 9:03 am
As matt has stated you need to add "FailoverPartner=ServerB" to your connections string (assuming your using OLEDB).
Matts link show with diff values for other providers.
This also is the same for SQL 2005 (see link - they are the same).
http://msdn.microsoft.com/en-us/library/ms366348(SQL.90).aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply