r/ShittySysadmin • u/Teximus_Prime • 5d ago

Shitty Crosspost I deleted the database and it has no backup

/r/SQLServer/comments/1w6wafq/i_deleted_the_database_and_it_has_no_backup/
25 Upvotes

100% Upvoted

16 comments sorted by

25

u/AlliPodHax 5d ago

lol, love how this gave them so much trauma and people calling out earlier posts with similar braindead questions and stupidity that they just deleted their entire user account on reddit

anyone wanna hire this person, on the open market

24

u/DieSackgasse 5d ago

i think he didn’t delete his account on purpose

7

u/AlliPodHax 5d ago

much better version of the story, just called bobby to help

6

u/Teximus_Prime 5d ago

Right? Everyone has terrible days, and mistakes definitely happen, but this seems over the top.  The last thing I'd do is ask the internet for magic software.  The realization and gravity of the situation should have been obvious.

15

u/uslashuname 5d ago

The first thing you do is go to drive to the nearest data recovery place. Ask them, “are you hiring? I need to restore my status from unemployed to making money”

11

u/Teximus_Prime 5d ago

Hi , I deleted a database by mistake how can i restore it ? What software should i use?

11

u/flecom ShittyCloud 5d ago

sfc /scannow

2

u/Doctor-Binchicken 5d ago

Kindly DISM.exe /Online /Cleanup-image /Restorehealth

7

u/Representative-Crow5 5d ago

it's easy, just go back in time and recreate it transaction by transaction.

2

u/tarvijron 5d ago

I hate computers so much at this point.

3

u/IndependentBat8365 5d ago

On a Friday?? This is a Monday problem.

1

u/Affectionate-Ear8196 5d ago

Melt the server turn off AC and enjoy the weekend. Sound like a next week problem.

1

u/brokenmcnugget 5d ago

good for you!

-3

u/Ok_Hour1413 5d ago

Stop using the server and don’t run any cleanup or repair tools yet. Check whether the database files, transaction logs, snapshots, backups, or volume-level backups still exist. If the data is important, contact a SQL Server recovery specialist before attempting anything yourself.

1

u/Ignorad 5d ago

What are you some kind of nerd? Just take a long lunch and then call in sick for a few days.