ethical question

  • rk1980factor

    SSCommitted

    Points: 1681

    I was working remote, trying to clear your queue in order to start with a clean slate the following week. Everyone was gone for the day. My last task is to delete 25 rows from a production table but accidentally deleted 25000 rows from the table.DB is log-shipped to another instance, so was able to grab the data and replace it in production. But I am puzzled since than if I should tell anyone about this and or should I keep quite and what should be the reasoning behind my action.

  • Grant Fritchey

    SSC Guru

    Points: 396715

    Absolutely tell your manager, boss, team lead whatever. You don't need to tell the whole company. However, you don't want to look like you're attempting to hide it. Honesty and clarity are always the best policies. Now, I dropped a table in production once. The phone started ringing while I was fixing it. I fixed it, answered the phone, and told the people on the other end, "Yeah, there was a glitch, but it should be online now, check again." I didn't tell them what I did. However, I went straight to the boss to let her know. Nothing ever happened from it, but my bottom was covered if something did.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Jeff Moden

    SSC Guru

    Points: 997170

    This sounds like an interview question... especially since you've asked so many similar questions.

    I'll give you some hints, though...

    BEGIN TRANSACTION

    ABSOLUTE HONESTY

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • ZZartin

    SSC-Dedicated

    Points: 30420

    Tell your boss or manager or whatever but make sure you have a good understanding of actual impact before you do.  That conversation can have a very different tone if it's I deleted a bunch of rows and our international sales website was down for an hour vs I deleted some rows in an internal database and the only people who use it were gone for the day so it's a good thing I did it after hours.

  • tripleAxe

    SSCertifiable

    Points: 5605

    Definitely tell your boss.  They might know about the ON DELETE CASCADE foreign key constraint....

    There may well be other stuff affected that you do not know about.  Tell them what you've already done to get the data back.  Next time tell them first before you start the recovery actions.

  • Lynn Pettis

    SSC Guru

    Points: 442360

    Never hide a mistake, that will get you more trouble than the actual mistake.  Tell your supervisor or manager.  leave it up to them if it should go higher.

     

  • Jeff Moden

    SSC Guru

    Points: 997170

    Heh... and here we are trying to teach someone on an interview to be either a DBA or a Developer how to be ethical.  This should be an innate attribute of the interviewee for either of those positions.  They should already know the answer.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • oogibah

    SSC Eights!

    Points: 802

    For sure, it sucks when stuff like this happens but a good boss will be understanding and happy that you owned up to the mistake and let them know about it.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply