Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Josh on November 03, 2015, 01:29:01 AM

Title: You are leading a DBA team and one of your team members came to you and reported that he has executed an UPDATE command without WHERE CLAUSE on production database. Now that entire table has got updated with the wrong data. How do you handle the situation
Post by: Josh on November 03, 2015, 01:29:01 AM
Hi all, I have a problem to submit because I can not find the answer elsewhere, you are leading a dba team and one of your team members came to you and reported that he has executed an update command without where clause on production database. now that entire table has got updated with the wrong data. how do you handle the situation? It is urgent, thank you very much for informing me quickly.