DBA 101: Why Don’t People Run Backups
It happened multiple times this week. It happens multiple times every week. Some poor soul is posting on a message board, usually with the heading “URGENT†(why that one word so frequently, I just don’t know), that they deleted production data/dropped a production table/updated production data/dropped a database/received a data corruption error/whatever. Now, they need to get the data back. “URGENT, What do I do now?†And so you ask, as you should, what kind of backups do you have? Over and over the answer is: “Backups? What’s a backup†or “Oh, the system guys backup of the MDF files every night†or “We don’t really need those†or “We don’t have room to back up our databases†or some other excuse that simple comes down to, we didn’t set…