Comparing SQL Mirroring to Clustering

wkhazzard — Fri, 21 Mar 2008 13:33:51 GMT

I'd like to hear the thoughts of other DBAs and Architects who've used both SQL Mirroring and SQL Clustering. My company, SnagAJob.com, is currently using SQL Mirroring for our production OLTP databases. We have issues almost every day: mysterious failovers, ADO.NET clients that repeatedly attempt to connect to the mirrored server instead of the primary (because they believe it's failed over). We're fairly certain that it's not networking issues because we see these same issues in our lab environment when everything is connected on a single gigabit switch. This would be a great topic for a future meeting, in my opinion, especially as more of a round-table type of discussion.

Search results matching tags 'mirror', 'failover', and 'error'

Comparing SQL Mirroring to Clustering