|
|
|
|
|
by keefe
3698 days ago
|
|
How often did the Model T break down compared to the cars of today? (hopefully the stats backup that conceptual point) Mistaks happen all the time. My great grandfather lost three fingers in a printing press accident. That is this kind of accident: "I once switched a production SQL database to Simple recovery mode and Truncated an important table causing a ton of work for my colleagues." How does that even happen... |
|
I was setting up a staging database for some testing. Our DBs are big so we truncate a bunch of data we don't need on the staging server so we can have more DBs without wasting tens of GB per database.
I ended up executing this against the wrong server.
Needless to say, we've learned from this. Luckily nothing critical was lost, but I felt like a complete spanner :(