• 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

    3 DBA's

    Free coffee

    :Whistling: