Stupid users again.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • UtwigMU
    Super MURCer
    • Jul 2002
    • 5651

    #1

    Stupid users again.

    So aspiring developer coworker wrote in the email today: I can't access SQL database on machine (among other stuff probably because I deleted .ldf file because it was taking too much space).

    Of course you can't access SQL database if you erased transaction log file of that database.

    I had to restrain myself not to send ROFLCOPTER as a reply.

  • UtwigMU
    Super MURCer
    • Jul 2002
    • 5651

    #2
    ldf is a transaction log of SQL database. Here the data that's needed to recreate database in case of failure goes and logs are flushed on backup. If the log is gone, you loose state of database. This guy was a developer who works with SQL databases daily, he was supposed to know what a transaction log is.

    Comment

    • VJ
      Moderator
      • Mar 2001
      • 9733

      #3
      You did tell him he was working on the *only* copy in existence of that particular database?
      pixar
      Dream as if you'll live forever. Live as if you'll die tomorrow. (James Dean)

      Comment

      • UtwigMU
        Super MURCer
        • Jul 2002
        • 5651

        #4
        Data wasn't important, it was performance testing development server runing in virtual machine. Still I spent 3h fixing it.

        Comment

        • VJ
          Moderator
          • Mar 2001
          • 9733

          #5
          I can imagine... but just to make him feel more uncomfortable...
          (I'm just that evil...)
          pixar
          Dream as if you'll live forever. Live as if you'll die tomorrow. (James Dean)

          Comment

          Working...