Steps for Refreshing a Pre-PROD database to that of PROD

Ø  Check the free space and Size of the database.

Ø  Take a backup in Prod and copy it to Destination Server(DEV\QA\UAT)

Ø  Take backup of users and permissions of Pre-PROD DB

Ø  Take backup of destination if its small(less than 1 or 2GB)

Ø  Import the dump using the script

Ø  Run the users and permissions script

Ø  Cross verify DB and users permissions