SQL Database and Power Cut

Forums › IT Pro and developers › SQL Database and Power Cut

networkn

Networkn
32862 posts

Uber Geek
+1 received by user: 15453

ID Verified

Trusted

Lifetime subscriber

#103108 30-May-2012 16:51

Hi There!

Anyone ever seen a situation where an abrupt loss of power on a server (Not graceful) will result in the loss of both the mdf and ldf files from an sql server and the sql instance service switching to "disabled"?

Was a virtual machine (VMWare Server)

Zeon

3926 posts

Uber Geek
+1 received by user: 759

Trusted

#632735 30-May-2012 17:02

I've seen power loss causing corruption on MySQL if that helps?

Speedtest 2019-10-14

networkn

Networkn
32862 posts

Uber Geek
+1 received by user: 15453

ID Verified

Trusted

Lifetime subscriber

#632737 30-May-2012 17:05

Sure, I have seen corruption too, but not complete loss of both files entirely and services being set to disabled.

Regs

4066 posts

Uber Geek
+1 received by user: 206

Trusted

Snowflake

#632770 30-May-2012 17:47

did the files completely disappear? have never seen that happen before. would indicate FAT or MFT corruption. were the files hosted on FAT or NTFS? Did a chkdsk get run?

Sales Engineer
Snowflake
www.snowflake.com

about.me/nzregs
Twitter: @nzregs

kyhwana2

2572 posts

Uber Geek
+1 received by user: 233

#632776 30-May-2012 18:00

Yes.
You need a UPS AND a BBU on your RAID card.
(Or if you are doing software RAID, a decent UPS + a proper shutdown plan that works automatically)

gzt

18679 posts

Uber Geek
+1 received by user: 7809

Lifetime subscriber

#632833 30-May-2012 19:27

Were the files hosted on a different drive (different vmdk) and that drive is now not accessible?

but yeah, shut down the server and chkdsk the host.

jaymz

1136 posts

Uber Geek
+1 received by user: 76

#640384 13-Jun-2012 20:21

kyhwana2: Yes.
You need a UPS AND a BBU on your RAID card.
(Or if you are doing software RAID, a decent UPS + a proper shutdown plan that works automatically)

OP said it was a virtual machine.....

OP, I have only seen a similar issue when i performed a restore of a computer using ShadowProtect. Simply restored the files from another backup and it went fine.

Interesting that the files would disappear though.... would have thought it would have just been marked as damaged...

HP

Shop now for HP laptops and other devices (affiliate link).

networkn

Networkn
32862 posts

Uber Geek
+1 received by user: 15453

ID Verified

Trusted

Lifetime subscriber

#640398 13-Jun-2012 20:54

Well it wasn't just the the files went, it was the fact the instance contained no databases either, and the service was disabled. Weirdest thing I've seen in a long time. Can't think of a single explanation.

jaymz

1136 posts

Uber Geek
+1 received by user: 76

#640406 13-Jun-2012 21:06

Were there any updates installed pending a reboot? Server had graceful restart recently?

Any errors/clues in event log?

Very strange indeed!