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 |
|
nimesh69
Starting Member
30 Posts |
 Posted - 2001-06-26 : 18:01:02
|
| Hi All,I'm using sql7. I've created a login say test and created user "test" in the database for that login.Now, when I backup DB from one sql server and restore it on the other server that too has login called test, it says restored successfully. When I open that db it doesn't show me the user "test".If I attempt to create one, it gives me an error saying the user already exists.This seems contradicting as on the one hand it doesn't show "test" user and on the other hand it says user already exists.I have found a work around for this though.I create a new database with user "test" and then I import from the restored database which gets all the objects and brings db exactly how it is supposed to.Am I doing something wrong?Does anyone know how to fix this problem?Appreciate your help.Thanks!- Nimesh |
|
|
|
|
|
Restore doesn't get db user