Using Your Test Environment for Updates
Before updating the servers in your production environment, always deploy and test your updates in a separate staging/test environment. This will help ensure that you deploy a fully tested and updated site efficiently.
For example, suppose you update your product catalog. Before you modify the catalogs in your production environment, update the ones in your staging environment first. Test the updated catalogs there. Once you are satisfied that these updates are fully functional, use SQL Server to replicate the updates to your production servers.