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?

"Schrott" (german) == "junk"

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?

This seems farfetched... You sure you didn't get hacked?

@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"...

Fuck that man :/ i feel for ya

That's not standard procedure... It should mark the table as crashed and wait for further instructions

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.

May I ask you what SQL and OS version you are using?

@Noren MS SQL Server 2012 R2 (not quite sure atm) on a Windoozle Server 2008

@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)