Database refresh:

When someone asks you to refresh a database, please be sure to ask them the below source and destination server information...

Source Server:

Server Name: PROD\Inst1,12000

Database Name: SQLSERVER

ENVIRONMENT: PROD

Destination Server:

Server Name: TEST\Inst1,12000

Database Name: SQLSERVER

ENVIRONMENT: STAGING

Remember when you restore database on staging server...

1. First thing would be to extract the permissions.

2. Restore the database on test server from most recent available backup from PROD.

3. Re-apply the permissions which you have extracted in first step.

You could find Script to extract the permissions here.....

http://www.sqlservercentral.com/scripts/Security/71562/

Hope this helps 🙂