April 15, 2016 at 7:54 am
Brandie Tarvin (4/15/2016)
Grant, your second link is gone.This question was removed from Server Fault for reasons of moderation. Please refer to the help center for possible explanations why a question might be removed.
This one works just as well
http://serverfault.com/questions/587102/monday-morning-mistake-sudo-rm-rf-no-preserve-root
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2016 at 8:10 am
Brandie Tarvin (4/15/2016)
Grant Fritchey (4/15/2016)
Backups. What are they good for?[/url]and, more recently:
How to recover from deleting everything, including the backups
I sincerely hope that this data is not vital to your organization, because it's gone.
Grant, your second link is gone.
This question was removed from Server Fault for reasons of moderation. Please refer to the help center for possible explanations why a question might be removed.
One of the reasons I'm less than enamored with Stack Overflow. Here's the full story [/url]on the removed question (because it's "duplicate" except it isn't <sigh>). If anything though, Stack Exchange is helping the poor person involved by ensuring that there is one less place on the internet that mentions his spectacular failure.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 15, 2016 at 9:17 am
My sympathy to the loss of your database.
Like the others, I really do hope you a) have a backup and b) can convince the boss to hire a dba.
Three days spinning on this is far too long in my opinion.
I also agree with the others on the need for a backup and like the link Grant posted. If you read that first article, it underscores that a backup is not a backup until it is tested. That means you have to restore the backup and verify that it worked. Data is far too important to not do these simple things.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 15, 2016 at 11:23 am
I'll echo my sympathies.
I'll also say that you should setup a backup when you create a db. That's a good time to just make sure you at least run one once a day, and keep two old ones. You can get better from there, but that's a good minimum.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply