Last week, I asked y’all how frequently you ran your full backups, corruption checks, index maintenance, and stats updates. The results after over 1,000 responses:
A few thoughts:
You’re typically taking full backups daily or weekly. I’m actually surprised by how many folks do weekly backups! That kinda scares me because if the backups take so long that you can’t do ’em overnight, then you’re probably gonna be horrified by restore times when things go wrong. You’ll have to do that big long full restore, plus the most recent diff. If you’re in that situation, you really wanna start