Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I compare with a backup why are the Windows logins lost and the database users using the username as login name?

April 26, 2017backup compare database LOGIN logins Lost username Users Windows

0

Posted

When I compare with a backup why are the Windows logins lost and the database users using the username as login name?

1 Answer

0

Posted

Some login info is stored in the master database. This is not part of database backups. If you are running SQL Compare in a Windows domain that is not the same domain as where the backup was made the login info cannot be accurately retrieved.