DB refresh and user creation after refresh | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DB refresh and user creation after refresh

Hi I have to do one DB refresh from Prod to Dev, also i need to transfr all users and permissions. which among the following step is good .
1)transfr logins first then refresh DB
2)refresh DB first, then transfr logins Please adivice.. *After refresh and creating logins, is there any way to set default DB for users, as in Production. Suppose i have 300 users.If its less no: i can set it one by one. I think all DBAs have worked on this kind of issues thanks
Hi I think i got the solution to this . DO the DB refresh first , then the copyin of logins else..
the default databases of each login will be all messed up.

If these are SQL logins then you can use SP_CHANGE_USERS_LOGIN in order to fix them. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.