SQL Server Performance

Dbusers restore

Discussion in 'Getting Started' started by reethu, Aug 15, 2008.

  1. reethu New Member

    Hi i am doing now a days lot of cross database restores , it is getting very hard restoring users back to the database
    because the restore is from diffrent database not same as existing one.when i restore from it loosing all users and
    do any one have best idea to restore users back with the same permissions.
    what are best proctices to do this kind of hetero restores.
    Thanks in advance
  2. satya Moderator

    First and best thing is to script all the permission from the source database to retain, once you restore the database then you could reapply them on target server.
    Also for orphaned users you could try SP_CHANGE_USERS_LOGIN to fix.

Share This Page