Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2002-04-22 : 07:21:18
|
| Dear Folks,I restored a test database from a copy of its life database, using a backup of the life database. This resulted in loosing users within the test database. That is , i lost users initially in the test db as well as those i expected to be imported from the restore. Question is what could be the possible reason for this and what is the best possible solution. I am on a windows nt machine, sql server7.any suggestion would be well appreciated.Thanks,Victord. |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-22 : 11:27:57
|
| The users are still in the database, but they no longer match logins on the new server so they are invalid. If the logins exist on the new server, you'll just need to run the sp_change_users_login stored procedure for each one you want to resync. Look it up in BOL for more info.Jeff BanschbachConsultant, MCDBA |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-22 : 12:56:36
|
| Or use my script from the script forum.-Chad |
|
|
|
|
|
|
Restore Problems.