User mapping lost after manual failover
- by fordan
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 backup of database I always have to redo the login/user mappings. I understand this because the logins are per database server. So after restoring the…