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. 🙂