Post reply

ReApplying LOGINS, USERS, and ROLES

  • April 25, 2006 at 12:31 pm

    #190284

    I need to restore a "QA" SQL Server 2000 consisting of 12 DB's from Production DB backups.  FIRST, I want to script out the existing "QA" DB LOGINS, USERS, and ROLES --- to be reApplied after the Restore (then SIDMAP'd)

    Do I need to iteratively generate the LOGINS, USERS, and ROLES for each of the 12 DB's?

    Thinking, I need to prep 13 scripts --- 1 for ALL "LOGINS and USERS" and 1 Script (per 12 DB's) to capture the  USERS and ROLES in each DB.

    Am I taking the correct approach here?   Other than scripting via E/M, is the a shortcut proc available to do this?

    BT

  • April 25, 2006 at 3:16 pm

    #634172

    Are these databases all off of the same production server.  If they are I would copy the users and sids from the production server and create them on the QA server.  Then there is no need to do any other steps past the restore.

    Tom

  • April 25, 2006 at 3:58 pm

    #634179

    That is correct, you just need to make sure the logins are recreated with the correct SID in the master database.  Roles and permissions for the users will be restored with the databases.

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

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