[
From Microsoft Certified Professional Magazine]
Because SQL Server manages SIDs for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem and here's why.
The article continues at
http://mcpmag.com/columns/article.asp?editorialsid=2852