I have a windows service application that is instaled on two servers, SQL01 and SQL02. On both server there is a SQL server (X1 and X2), which have the same content. A mirroring partnership was set up for one database, called Interface.
Both service connect to their local database and have therefore no knowledge of the other one. The service is pretty simple, it reads from the database and perform some manipulation before sending it to a distant database(the same for both instance). A simple fonction is used to determine if the database is available or not using a dummy SELECT. If the database answer, then it's available, otherwise it's not.
When we started the whole thing the first time, only one database is working obviously (because of the partnership). However, when we do a manual failover, it seems that the database is still available! should I restart the service, it stop doing so and restart to work the way it should.
As far as I can tell, I don't keep any connection open to the database. I open and close them as soon as I am done with the query.
Does anyone have any idea of what could be happening ?
Thanks,