sqlserverdba
asked on
revlogin before or after restoring databases
we are restoring databases to another server. If we execute the output of sp_help_revlogin on destination server first and then restore databases on destination server, will it reduce orphaned users?
or is it the same as restoring databases and then transferring logins later?
are there any pros and cons of these two methods?
or is it the same as restoring databases and then transferring logins later?
are there any pros and cons of these two methods?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so which is the best way to fix the orphan users? the change users login procedure with autofix or update?
i am restoring the same backup as different databases with different names, so was just wondering if it makes any difference or any problems?
is the procedure still the same?
i am restoring the same backup as different databases with different names, so was just wondering if it makes any difference or any problems?
is the procedure still the same?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The reason is that some of the batches may break if the destination databases being referred to are not there.
On the contrary, if you execute the output of the procedure after restoration, there's no problem at all.
Either way, orphaned logins will always come with the database(s) being restored.