Results 1 to 4 of 4

Thread: Restore problem

  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Unanswered: Restore problem

    Since i need to restore my database to another machine, I am now encountering a problem with my db.

    Because some login does not exist on the new machine and I need to re-crerate the login in it. However, i found an error message 'User ???? already exist'

    Is it possible that i could drop my existing user but some of them are objects/db owner.

    many thanks!

  2. #2
    Join Date
    May 2002
    Location
    Brisbane, Australia
    Posts
    13
    You got the same problem as me.. see http://dbforums.com/t547764.html

  3. #3
    Join Date
    Oct 2002
    Posts
    2
    Originally posted by Nigorr
    You got the same problem as me.. see http://dbforums.com/t547764.html
    I just find a solution and it fixed my situation and hope it could help you.

    I used the sp_change_users_login to associate the login and user.

  4. #4
    Join Date
    May 2002
    Location
    Brisbane, Australia
    Posts
    13
    thanks, why didn't they(MS) provide a way to do this in enterprise manager???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •