SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 It's dead, Jim
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 17

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 03/16/2009 :  11:53:51  Show Profile  Visit spirit1's Homepage  Reply with Quote
that's really old news!

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 03/16/2009 :  12:09:05  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
There's been a second case of that much more recently.

http://www.brentozar.com/archive/2009/03/backup-fail-magnolia-goes-under/

Two in 3 months. When will people learn?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

jimf
Flowing Fount of Yak Knowledge

USA
2869 Posts

Posted - 03/16/2009 :  13:16:54  Show Profile  Reply with Quote
I guess having your back up against the wall doesn't count as a strategy?

Jim
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 04/09/2009 :  13:43:44  Show Profile  Reply with Quote
Dead Jim Walking:
http://www.sqlservercentral.com/Forums/Topic692573-357-1.aspx
"We have San replication, so we switched off tape backups…"






CODO ERGO SUM
Go to Top of Page

uberman
Posting Yak Master

159 Posts

Posted - 05/15/2009 :  05:36:45  Show Profile  Reply with Quote
http://news.bbc.co.uk/1/hi/technology/8049780.stm
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 05/23/2009 :  16:23:48  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
<sigh>
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126304
Log file reached 800 GB (yes, GB). Detached DB, deleted log file. Database won't reattach. No backups.

Why???????

--
Gail Shaw
SQL Server MVP
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 05/26/2009 :  10:37:28  Show Profile  Reply with Quote
Found in the Data Corruption forum. Maybe you should create an Employee Corruption forum to better address the issue?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126394
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 05/26/2009 :  12:04:42  Show Profile  Reply with Quote
quote:
Originally posted by mcrowley

Found in the Data Corruption forum. Maybe you should create an Employee Corruption forum to better address the issue?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126394


"Accidentally i deleted half the tables from our application database. I need to restore/recover them in 4/5 hours else, i am will be out of this world !!..."

The OPs deadline is long past, so I wonder what happend to them?


Not sure what good an Employee Corruption forum would do. Seems like the answer would always be, "Don't do that!"






CODO ERGO SUM
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 06/04/2009 :  14:49:34  Show Profile  Reply with Quote
Not dead because of backup, but all of the nice advice on how to hang yourself!

http://www.dbforums.com/microsoft-sql-server/474926-_log-ldf-became-giant.html

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/05/2009 :  02:24:57  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Ow, ow, ow, ow.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/01/2009 :  14:58:05  Show Profile  Reply with Quote
I accidentally deleted the whole company, Jim.


Death by Delete
http://thedailywtf.com/Articles/Death-by-Delete.aspx
"...
One day, a developer was optimizing the database and removing records that MegaPetCo no longer needed. All it took was a single, poorly formed delete query to wipe out each and every row in the database table.

To say the developer panicked is akin to describing a quadruple amputation as a mere flesh wound. MegaPetCo's sales immediately ground to a halt. Along with everything else. Payroll, logistics, reporting, purchasing, you name it. Its Web site didn't work -- but that was the least of the company's worries. The status of its backups was bleaker still: None. Zip. Zilch. Nada.
...
...
Unfortunately, the single delete query proved to be far more than MegaPetCo could bear. Within a few months, the company filed for bankruptcy and was forced to close every one of its stores -- laying off several hundred people along the way."



CODO ERGO SUM
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 07/06/2009 :  16:51:23  Show Profile  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

I accidentally deleted the whole company, Jim.


Death by Delete
http://thedailywtf.com/Articles/Death-by-Delete.aspx
"...
One day, a developer was optimizing the database and removing records that MegaPetCo no longer needed. All it took was a single, poorly formed delete query to wipe out each and every row in the database table.

To say the developer panicked is akin to describing a quadruple amputation as a mere flesh wound. MegaPetCo's sales immediately ground to a halt. Along with everything else. Payroll, logistics, reporting, purchasing, you name it. Its Web site didn't work -- but that was the least of the company's worries. The status of its backups was bleaker still: None. Zip. Zilch. Nada.
...
...
Unfortunately, the single delete query proved to be far more than MegaPetCo could bear. Within a few months, the company filed for bankruptcy and was forced to close every one of its stores -- laying off several hundred people along the way."



CODO ERGO SUM



MVJ - And how many times have we seen that?? I deleted my data and I don't have a backup - how do I get my data back???? Can you say "unemployment"????? Or even spell it? I have no pity for folks like that. Disgust, maybe, but zero sympathy......

Terry

-- Procrastinate now!
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/06/2009 :  17:16:19  Show Profile  Reply with Quote
I shot myself in the foot, then shot the other foot trying to fix it, Jim.

http://www.sqlservercentral.com/Forums/Topic748016-1292-1.aspx

also posted on SQLTeam:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=128827




CODO ERGO SUM
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 07/13/2009 :  11:52:09  Show Profile  Reply with Quote
I threw my DB into a woodchipper Jim.
http://www.dbforums.com/microsoft-sql-server/1645099-sql-server-2008-database-truncated.html

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/14/2009 :  03:47:01  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
That's been posted everywhere. SSC, here and now DBforums. Wouldn't be surprised to find it on the MSDN forums as well.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/17/2009 :  14:02:50  Show Profile  Reply with Quote
Dropped database by accident, no backups, need to get it back, ...blah, blah, blah..., Jim.

http://www.sqlservercentral.com/Forums/Topic754888-357-1.aspx






CODO ERGO SUM
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 08/05/2009 :  08:28:44  Show Profile  Reply with Quote
Doomed
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=129553

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 08/05/2009 :  09:44:51  Show Profile  Reply with Quote
quote:
Originally posted by DonAtWork

Doomed
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=129553

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Well, hopefully he/she will learn.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 08/05/2009 :  10:53:07  Show Profile  Reply with Quote
quote:



And keep your eye on the sparrow.
When the going gets narrow.



http://www.lyricsondemand.com/tvthemes/barettalyrics.html


Sing it Sammy!



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam




Edited by - X002548 on 08/05/2009 10:53:27
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 08/10/2009 :  17:01:37  Show Profile  Reply with Quote
Another one! Someone dropped it but I have no backup!!!!

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/bfcddeb1-b45d-41d7-abe7-33d25600397f?prof=required


Terry

-- Procrastinate now!
Go to Top of Page
Page: of 17 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000