Hallo SQL jedis,
I want my database to be always available. So I've set up database mirroring, which is working peachy.
My question though, is how can I consistently address the database? I want database access to be transparent of the underlying mirror status. Currently, if I'm sending traffic to SQL-SERVER-01, and a failover is triggered, my traffic now needs to go to SQL-SERVER-02.
Is there any way to abstract that? Can I use the clustering feature of Windows Enterprise to have one virtual IP address that automatically floats between whichever is the primary SQL mirror?