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