Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


networkn

Networkn
32350 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

#103108 30-May-2012 16:51
Send private message

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)


Create new topic
Zeon
3916 posts

Uber Geek

Trusted

  #632735 30-May-2012 17:02
Send private message

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




Speedtest 2019-10-14




networkn

Networkn
32350 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #632737 30-May-2012 17:05
Send private message

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

Trusted
Snowflake

  #632770 30-May-2012 17:47
Send private message

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?






kyhwana2
2566 posts

Uber Geek


  #632776 30-May-2012 18:00
Send private message

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

gzt
17111 posts

Uber Geek

Lifetime subscriber

  #632833 30-May-2012 19:27
Send private message

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
1133 posts

Uber Geek


  #640384 13-Jun-2012 20:21
Send private message

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...

networkn

Networkn
32350 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #640398 13-Jun-2012 20:54
Send private message

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.

 
 
 

Free kids accounts - trade shares and funds (NZ, US) with Sharesies (affiliate link).
jaymz
1133 posts

Uber Geek


  #640406 13-Jun-2012 21:06
Send private message

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

Any errors/clues in event log?

Very strange indeed!

Create new topic





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.