Tagged Questions

1
vote
1answer
38 views

Backing up a mirrored SQL environment

I have 2 SQL servers in Mirror configuration. I want to backup these servers but backing up the SQL databases in Mirror state causes an error. These two mirrors also have a witness set. I would ...
1
vote
1answer
155 views

Addressing SQL 2008 mirror cluster

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 ...
1
vote
1answer
535 views

Login failed for user 'XXX' on the mirrored sql server

We have 4 web servers that host our asp.net (3.5) application. Randomly, we get error messages like : 1) "Login failed for user 'userid'" 2) "A network-related or instance-specific error occurred ...