According to Microsoft, you can use the contained database model to make the database more portable. This prevents orphaned users after a restore by authenticating accounts directly at the database ...