1 Dev environment
1 Integration environment
1 Acceptance Testing environment
1 Automated Testing environment
1 Production environment
Backups weekly full, nightly differentials (unless diff is 50% size of database then take fulls), hourly transactionals
We have an ETL out to pre BI staging area which concievably can be reversed to recreate any database in that process.
187TB of data 150 plus servers, 800 plus databases