Danny,

I think this is to do with connection pooling. Once your web app connects to the primary the connection is held in a pool. This pooled connection will...

Thanks Wayne,

Good to know that it should work if we go that way.

The main reasons that management are keen to stay with 2003 are:

1. This a a hardware refresh of...

Jody,

I'm not sure of the specifics of your environment, but what I did in our dev environment while playing around with mirroring was to set up an event trigger on...

Jody,

I'm not sure if I understand what you are trying to achieve. Mirroring the DB with a witness will make the DB highly available but if you only have...

Ryan,

Slightly off topic but, it sounds to me you are using mirroring for HA and replicating your mirrored DB. Do your subscribers also need to be highly available?

We looked...

Perry, even using .net your failover might not be seamless if you are using connection pooling. Atleast that has been my experience.

Hi,

As others have already mentioned, the technology you use is dependant on wht you are trying to achieve.

We use clustering for High Availability. Transactional replication to maintain an up...