Running a database mirror setup with the SQLBrowser service off may produce unexpected results.

I had an interesting case the other day which I thought I’d share some information on here.Basically the setup was a SQL Server 2008 Database Mirror setup and the connectionstring looked something like this: @”Data Source=SERVER_A\INSTANCE_A,12345;Failover Partner=SERVER_B\INSTANCE_B,54321;Initial Catalog=MirroredDatabase;”; Perhaps you’ll notice that the connectionstring contains both server and instance and port number.In this case the…

3

Clarification on the Failover Partner in the connectionstring in Database Mirror setup.

There is a common misunderstanding on how the Failover Partner keyword in the connectionstring works in a database mirror setup.This is my attempt to clarify a bit on this. From the documentation we can see the following: “Failover Partner – The name of the failover partner server where database mirroring is configured.”This then suggests that…

9