Login Users when backingup

  • Hi all,

    I'm able to backup and restore the data of the database.

    How do I move the Login users' details also along with the data backup?

    Thanx in advance

    Parasu Raman


    Regards
    Parasu Raman

  • There is a DTS task to do this in SQL2000 I think. The data is in sysxlogins, you can bcp it over, or use sp_addlogin. Be sure to check for orphaned users when you're done, take a look at sp_change_users_login. I have a related article and so does Neil I think.

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply