It was my third year of my first job, I was alone working on the live database. I ran the following SQL command in SSMS:
DELETE FROM TABLE WHERE ID = something
And the table had a million records. Guess what!
In SSMS, the DELETE FROM TABLE was selected.
It took an hour to restore from backup, it stopped a lot of people from working, many new records was lost, they had to keep pile of papers to enter into syatem again.
DELETE FROM TABLE WHERE ID = something
And the table had a million records. Guess what!
In SSMS, the DELETE FROM TABLE was selected.
It took an hour to restore from backup, it stopped a lot of people from working, many new records was lost, they had to keep pile of papers to enter into syatem again.