68

You know your week starts great, when you receive a call, that the whole shop database of a company is not working anymore.
Turns out MS Fucking SQL decided to drop all tables, just because the harddisk was full.

A SERIOUS FUCK YOU TO MICROSCHROTT!

It's not a lot of fun, when 15 people have to wait for you about 1 hour, until it is restored.

Why does this have to happen on a monday?

Comments
  • 13
    "Schrott" (german) == "junk"
  • 5
    i have never have that happen and i have been using sql server for a very long time..what version are you on ? the performance drops when the disk is full and it does not allow writes but i have not had sql srv drops tables at random. Are you sure it wasnt some user?
  • 3
    This seems farfetched... You sure you didn't get hacked?
  • 2
    @bondman @D--M Yeah, I thought that too, but checked the logs. There were a lot of messages about disk spave insufficient and the like.
    I'm not very experienced with MSSQL, but that is what happened... 1 of 8 DBs was empty. You could not fold it open in the SQL manager, but it was "online"...
  • 2
    Fuck that man :/ i feel for ya
  • 2
    That's not standard procedure... It should mark the table as crashed and wait for further instructions
  • 4
    Shitty admin. Shouldn’t run out of disk. Should have alerts when disk space is at a critical threshold. Should be using cloud based storage where more space can be provisioned when the need arises.
  • 0
    May I ask you what SQL and OS version you are using?
  • 1
    @Noren MS SQL Server 2012 R2 (not quite sure atm) on a Windoozle Server 2008
  • 1
    @DogBarq Haha yeah, that's absolutely true.
    Our problem was, that it occurred right about 6 hours before I already wanted to upgrade its hdd space (the server runs on vSphere).

    We shut down the old DC (Winfail Server 2003 😄) 6 days before and wanted to give the company 7 days until we would delete the 2003 VM, in case something was missing on the new server.
    At the time we decided the 7 days timespan, the DB VM still had 5 GB left, which should have been more than enough... 😅

    Murphy got us hard...

    The previous admin guy (worked at their company) created a real mess... all was extremely outdated, extremely stupid backup processes and the like. (There should be at least one older rant from me about that)
Add Comment