title: User With Login becomes User without login when restored to a different instance
body: <p>I have a number of SQL Server logins which are configured on Instance A. These SQL Server logins are explicity mapped to specific databases. These databases therefore have the Login name listed as a user in their security container. When I restore the backups from Instance A into Instance B, the database level user becomes a 'user without login'. The user exists at server level in Instance B and it is not a case of the login being orphaned. It literally becomes a 'SQL user without login' rather than a 'SQL user with login'. Does anybody have any ideas as to how to fix this issue? I have exhausted all my options thus far. Nothing seems to work apart from dropping the user at the database level and adding it to the login at server level for that database. However, I am not in a position to keep doing this as it is part of an automated process.</p>