SQL Replication - Best practice
Usual procedure for replication from PRODUCTION to QUALITY/TESTING:
Backup User rights from DB QS
Full Backup of DB PROD
Full Backup of DB QS
Overwrite QS DB with data from PROD DB
Overwrite User rights on QS DB with previous rights
Last updated