Tuesday, March 20, 2012

restore database --> dropuser

Third question:
I'm backing up a database which has some users.
When I try to restore it to another machine which has the same users and already has an old version of the database the database cannot be accessed. I must drop the users from the database by using the stored procedures sp_dropuser <username> and then add it again to the database from the Enterprise Manager.

Why this happens??

Regards,
ManolisIt tends to irritate the people you are asking for help when you simply repost the same question. Check your previous post (http://www.dbforums.com/t1202865.html) for an answer.

-PatP

No comments:

Post a Comment