When we restore a backup created with the command below we get all the security settings on the database level but the users on the engine level are not created.
osql -s myserver -E -Q " BACKUP DATABASE MyDB TO DISK = 'C:\SQLBackups\MyDB.bak'"
The main use of this user on the engine level is for connection purposes from the outside (e.g. IIS Application).
databaseName1 mapped to user databaseUser1
We want to know what backup to the original database engine we have to do to bring the connection users, with all their passwords and mappings. Any ideas?