Restoring db and losing login user.

MSSQL

Restoring db and losing login user.

---

AlanB 06-13-2007, 2:23 PM
It appears there is a problem with the control panel database restore option, whereby the user information against it is lost when you restore from a .BAK file.

Has anyone else come across this and how do you overcome it? Surely people change schemas and update their remote dbs all the time?