2
votes
3answers
909 views

User mapping lost after manual failover

I have two Microsoft SQL Server instances set up for mirroring each with a number of databases. There are a number of logins and for each database one or more user/login mappings. When I restore a ...
0
votes
2answers
2k views

How can I improve SQL server mirroring performance

(reposted from stackoverflow) I've setup SQL server mirroring, using 2 SQL server 2005 standard editions. When the application is being stressed, response times increase 10-fold. I've pinpointed this ...
2
votes
2answers
218 views

Login fails when using SQL Mirroring

I have a peculiar scenario where my mirrored database can't be accessed on one server but it can on the other. I've tried specifying a specific SQL login to get it working but when the database is ...