Bloody SQL Server Developers!!!!!

[MarillionFan]

I was going to work at home today. Having designed a fantastic reporting system in SQL Server using DTS & Excel I was awaiting the results to come to me this morning so I dont have to go to the office.

Anyway some freaking idiot has obviously scheduled it incorrectly as for the 2nd day they havent come through!!!!!

That idiot it me!!!!!

 

[wendigo100]

That idiot it me!!!!!

is me

Unless you mean the idiot hit you.

Either way, merry Christmas

 

[Bagpuss]

I feel another contract is about to be terminated

 

[lilelvis2000]

Don't worry - I once accidentally deleted the entire product file for a retailer. There was a backup...yup a single backup file which overwrote the previous nights backup..'cuz the DBA was too lazy/cheap to get a proper tape put in. Tip! when copying SPs from one SQL server to another tick off the "drop and recreate associated objects"(?) flag. Didn't discover this until Monday when the order refresh failed.

I had to rebuild the product file from a week old Oracle backup and by pulling the remainf products from the Linux warehouse fullfillment system. Took half a day and I cocked it up as afterwards all the new product numbers started with 2xxxxxxxx instead of 1xxxxxxxx. Brill!

I didn't hang around too long after that.

 

[Spacecadet]

done worse

Back in permie days I was once having to temporarily free a lot of space on a development box

I detached one of the databases, zipped up the datafiles, then deleted the data files, except i accidentally deleted the compressed file as well

No backups anywhere! about 2 months of someones work gone, i tried a few undelete utilities (paid for out of my own pocket) and couldn't get it back.

Ended up creating junk files of the same size, compressing them and then deleting them. I then "corrupted" the compressed file so it wouldn't open.

Very dishonest of me!! however kept me off the hook, the project was shelved the week after anyway and for reasons completely unrelated to my balls up

 

[Francko]

Has this turned into a "confession" type of thread?

 

[Weltchy]

done worse

Back in permie days I was once having to temporarily free a lot of space on a development box

I detached one of the databases, zipped up the datafiles, then deleted the data files, except i accidentally deleted the compressed file as well

No backups anywhere! about 2 months of someones work gone, i tried a few undelete utilities (paid for out of my own pocket) and couldn't get it back.

Ended up creating junk files of the same size, compressing them and then deleting them. I then "corrupted" the compressed file so it wouldn't open.

Very dishonest of me!! however kept me off the hook, the project was shelved the week after anyway and for reasons completely unrelated to my balls up

WHAT!!!!!!!!!!!!! THAT WAS YOU!!!!! WHY I OUTTAAAAA

 

[Spacecadet]

Has this turned into a "confession" type of thread?

I hope so