• I've only had to restore twice at my current job. Once when a developer dropped a table. That was reference data and restored from the previous nights backup. The other was a table was corrupt in production and I again had to get the data from the night before.

    Our current backups are copied from the network to an off-site location. I believe they keep 7 days, end of month and end of year. At the end of the year all the monthly backups for that year are deleted. At least that is the last I was told. I'm not given any insight into backup retention. That's all the networking guys domain.