- Adam Thurgar
No backups
Whilst doing a current system state assessment for a client of their SQL Server fleet, I found a number of production SQL Servers without any backup jobs. They have user databases, but they were not being backed up (and there was no maintenance). I found it amazing that having some database backup was not part of their SQL Server build. There are plenty of scripts out there to automate backups and maintenance.
I don't care how you do it, just backup your databases. It will make your life easier (and then at some time in the future - do a test restore).