Imagine that! Our database failed.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Site Related Discussions

Imagine that! Our database failed.

Author

Topic

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2005-09-16 : 23:19:16

We had a hardware failure on the database server tonight that led to a corruption of the database. After battling it for a while I surrendered and restored from last night's backup. So I'm afraid all your witty posts and helpful answers from today are gone. I sincerely apologize for this happening. In the five years the site has been active I think this is the first time we've lost any significant amount of data.

(And yes ... I know I should do backups more frequently. I'll have to look into it.)

So it's late and I'm calling it a night.

-Bill

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-17 : 01:39:12

Thanks Graz for working on it tonight!

It explains why some of the links in my subscriptions didn't work.

Tara

Kristen
Test

22859 Posts

Posted - 2005-09-17 : 01:43:50

Clearly this hiatus was in response the Jen's post about Fridays ... but that post has gone now so you'll have to take my word for it!

Thanks for sorting it out Graz

Kristen

PS Tara have you flown over to Europe to see us, or are you babysitting a Friday night emergency too?

Kristen

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-09-17 : 01:45:02

hey, the 456 posts I made today are gone!

-ec

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-09-17 : 01:49:09

From the post times, it looks like the backup you restored from was from around 2005/09/16 01:15.

CODO ERGO SUM

Kristen
Test

22859 Posts

Posted - 2005-09-17 : 01:56:22

"hey, the 456 posts I made today are gone!"

Test !

Kristen

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-09-17 : 01:57:44

It's like the movie Groundhog Day. We're doomed to wake up each morning and make the same posts over and over.

quote:
Originally posted by eyechart

hey, the 456 posts I made today are gone!

-ec

CODO ERGO SUM

Kristen
Test

22859 Posts

Posted - 2005-09-17 : 02:03:22

I'm gonna write some code to play the piano and make ice sculptures. May take a while.

What will the Sequel be I wonder ... </sorry>

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-17 : 09:51:00

graz, aren't you doing daily db backups and transaction log backups every 30 minutes??

Go with the flow & have fun! Else fight the flow

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-17 : 14:20:42

quote:
Originally posted by Kristen

PS Tara have you flown over to Europe to see us, or are you babysitting a Friday night emergency too?

It was only 5:40pm over here. On a Friday, that's pretty late but was helping developers sort out some data problems.

Tara

Kristen
Test

22859 Posts

Posted - 2005-09-18 : 02:10:24

"It was only 5:40pm over here"

Ah ... I assumed your post time of " 01:39:12" was local or at least a "USA timezone"

EDIT : Hmmmm ... my post is 5 hours behind, which is about right for USA East Coast. Ho Hum!

Kristen

SamC
White Water Yakist

3467 Posts

Posted - 2005-09-18 : 10:07:51

quote:
Originally posted by graz

We had a hardware failure on the database server tonight that led to a corruption of the database.

Any words for us on what kind of hardware failure led to the corruption?

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-09-18 : 14:22:04

Catastrophic nuclear meltdown.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-09-18 : 16:52:35

Don't worry Graz. Your uptime is about 10 trillion times better than this site (error from today):

quote:

There seems to have been a slight problem with the dBforums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

And, all the posts from yesterday AND today are blank. It will let you reply to posts older than that though. It gives this error though when you try to save them. URRRRRRRRR

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-09-18 : 22:57:38

Ha, so this explains why I can't find my post...

Yap, do not perform any major database transactions on a Friday (Period with an exclamation point)

There's always a first time for everything Graz and we're just happy everything's back to normal again

Thanks

quote:
Originally posted by Kristen

Clearly this hiatus was in response the Jen's post about Fridays ... but that post has gone now so you'll have to take my word for it!

Thanks for sorting it out Graz

Kristen

PS Tara have you flown over to Europe to see us, or are you babysitting a Friday night emergency too?

Kristen

--------------------
keeping it simple...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-19 : 00:58:27

>>Yap, do not perform any major database transactions on a Friday (Period with an exclamation point)

Jen, Can you explain the reason?
I never heard about this problem and want to know what impact it will make

Madhivanan

Failing to plan is Planning to fail

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-09-19 : 05:13:16

huh?

assuming that you work from M-F regularly, making major changes/transactions on a friday especially nearing 5 pm will kill your social life

if anything untoward should happen (knock on wood)

most key persons will be out, even as early as 3pm, so if you're the last man out, you'll be left with the mess to deal with

though it was a mess that i initiated, so i had to stay till 8 pm

--------------------
keeping it simple...

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-09-19 : 05:15:03

ha ha ha, rotflol

this is ok to me, i only make an average of 2 or 3 posts a day...

quote:
Originally posted by Michael Valentine Jones

It's like the movie Groundhog Day. We're doomed to wake up each morning and make the same posts over and over.

quote:
Originally posted by eyechart

hey, the 456 posts I made today are gone!

-ec

CODO ERGO SUM

--------------------
keeping it simple...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-19 : 05:17:49

quote:
Originally posted by jen

huh?

assuming that you work from M-F regularly, making major changes/transactions on a friday especially nearing 5 pm will kill your social life if anything untoward should happen (knock on wood)

most key persons will be out, even as early as 3pm, so if you're the last man out, you'll be left with the mess to deal with

though it was a mess that i initiated, so i had to stay till 8 pm

--------------------
keeping it simple...

Well. I am not a DBA anyway

Madhivanan

Failing to plan is Planning to fail

X002548
Not Just a Number

15586 Posts

Posted - 2005-09-19 : 13:04:38

No sheet....

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

Kristen
Test

22859 Posts

Posted - 2005-09-19 : 13:50:55

Has your Excel "database" just crashed Brett?

Kristen

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources