Results 1 to 3 of 3

Thread: attach dataase with all users

  1. #1
    Join Date
    Dec 2012
    Posts
    1

    Smile attach dataase with all users

    hai

    How can i preserve all users while moving an mdf,ldf file from one system to another.
    when i tried to attach just by copying mdf and ldf file from on system to another ,all users created is lost.
    so please tell me how to preserve the existing users.


    thanks.

  2. #2
    Join Date
    Apr 2011
    Location
    Dallas, TX
    Posts
    57
    You did a "restore" vs. coping didn't you?

    Are the same users already created on the new system? Either way - odds are you'll have to re-attach them.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    You can copy sql logins along with pwd and sid using sp_help_revlogin, get sp here: http://support.microsoft.com/kb/918992.

Posting Permissions

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