I'm just another anonymouse sysadmin, but I wanted to make one comment: There needs to be a way to back-port the prod environment into test (and possibly even to dev). This way you can recover from situations where the upstream environments have become gunked-up with oddities that just naturally happen during the dev-test-prod cycle. And this backport from prod to test needs to be either a script, or a full backup/restore cycle, to ensure complete fidelity to prod.