Hi
Database refresh in the sense you have to take the backup of source server database ( Prod or any) and restore with replace on Destination server.
If you are using T-sql script make sure Logical names, Physical location and Physical Names.
Before doing this please run Sp_help_revlogin for scriptout the login on destination server after restore the database you have to sync the logins. this is called refresh the database if you need Sp_help_revlogin script findout in online or ping me. [Smile]
Thank you
Whether We need to run the Sp_help_revlogin script before restore the database in destination server or after restoring
Can you please provide the script
If we run the script orphan user problem will solve or not