• Its 8 for databases for our main production database

    Main Production System

    Production Support

    QA

    UAT

    Dev

    Internal Training

    External Training

    and a nightly refreshed Reporting DB

    If you include backups

    3 x Nightly Full backups on Disk for each DB bar the Reporting DB + 1 months on tape + 2 years of monthly tapes

    Which I make (3x7) + (31x7)[as July has 31Days!] + (24x7) + 8 = 414

    That was a bit of a surprise for my boss! He had guesstimated 40 odd

    Also coming soon a DR solution which will be a mirror of our entire IT Universe and as many nightly snapshots of individual servers as we wish

    https://blog.robsewell.com Its where I blog
    SQL Community Slack Channel https://sqlps.io/slack
    The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
    Data South West User Group http://sqlsouthwest.co.uk/[/url]