SQL Database Data Recovery In Hampshire

Despite falling out of favour in giant tech companies, there are not many businesses in the UK that don’t use some sort of SQL database. Whether that’s a website running WordPress & MySQL or an intranet hooked up to an MSSQL DB, SQL is still everywhere. Even iPhones use SQLite to store Notes and other data inside apps.

SQL Database Data Recovery In Hampshire
SQL Database Data Recovery In Hampshire

On Disk Problems

Sometimes the fault lies with the underlying disk, Virtual Machine, or RAID array that the file is stored on. First we solve the disk problem and then extract a working copy of the database.

Inconsistency

Another issue with database files is that they can go corrupt silently, and you might not notice until hours, weeks, or months later when a crucial process fails.

Our SQL recovery tools, alongside our hard disk & RAID recovery services can help get your lost databases up and running again with minimal fuss & downtime.

  • Peter MorganThese guys are amazing!! Really helped us out in an impossible situation with a corrupted SQL database which even the software provider couldn’t fix. Not only did they fix the corruption but they did it quickly and super professionally keeping us informed at every step of the way. I have used Dataquest many times and over the years and they always deliver. 4th July, 2017

Common Applications We Recover SQL From

  • Web server MySQL, PostgreSQL
  • Windows Application MSSQL

Why You Should Never Open A Hard Drive

See our video below to find out why you should never open a hard drive.

Transcript

Instead of a needle, hard drives use tiny magnets to read and write data. The heads don’t actually touch the disc.

But you’d only see that if you got close

Super close

The heads float just three nanometers above the disk

In comparison, a spec of dust in the air is 166 times bigger than the gap.

It would be like trying to kick a football through a gap the size of an ant

So if that giant spec of dust can’t fit through the gap, it will hit the read head

Bouncing it into the disc spinning at over 100mph

And scraping away chunks of disc within seconds

Up close the tiny scratches look like mountains

The heads can’t get past the damage so just scratch it even more

Until there’s nothing left but dust

This is what we call a head crash

Why You Should Never Open A Hard Drive

And This is Why You Should Never Open a Hard Drive! (Unless You Have a Cleanroom)

Contact Us Now...

For a fast reply from a real person.

How To Troubleshoot Western Digital Elements External Drive

How To Troubleshoot Western Digital Elements External Drive

Elements is the basic brand of external drives from Western Digital. These no-frills disks are usually great value, but when they fail have a few quirks that can make recovery a little awkward. For example the small pocket sized drives usually have a soldered USB port that cannot be removed. There is also automatic encryption, even if you’ve never set a password.

Symptoms of WD Elements Failure

  • LED permanently lit / blinking
  • LED not lighting at all
  • Clicking / ticking noise
  • Disk is not formatted. Do you want to format it?
  • Unable to see your data in Windows or macOS
  • Unable to copy or read files

Troubleshooting Ideas

If you have problems with a WD Elements drive, you should make some checks to see if you can narrow down the fault. Be aware that opening the external drive case will probably void your warranty with Western Digital. If there is important data on the drive you should seek professional data recovery advice before you try anything.

That’s the warning out the way, so lets have a look at some troubleshooting.

  1. First check all cables are plugged in securely, and not damaged or frayed. If you have an identical spare cable you can try it, just be gentle.
  2. If trying a different power supply, make sure the voltage matches exactly. Amps can be higher but not lower.
  3. There is little point dismantling a WD Elements drive, as there is usually no SATA connection inside. Even if you manage to bypass the USB Port, your data will be encrypted.
  4. It’s worth plugging the external drive into another computer. If it seems to work you should copy the data off straight away. The drive could still be faulty & fail again soon.
  5. Whatever you do, don’t dismantle the actual hard drive. Hard drives are built in controlled clean-air environments and even the smallest spec of dust can cause permanent damage to the drive.
  6. These external drives are quite unique in the way they work. It is not possible to replace the circuit board (PCB) on these disks, as your PCB contains important encryption keys. On the offchance that a replacement PCB worked, your data would be scrambled anyway without access to specialist decryption tools.

If you are looking for a data recovery service for your external hard drive have a look at our external drive recovery services.

Troubleshoot WD My Passport External Hard Drive

Troubleshoot WD MyPassport External Hard Drive

Unlike most external hard drives, WD (Western Digital) My Passport drives are more than just a simple wrapper around a regular hard drive. WD have integrated the USB port straight onto the main circuit board. This means if your external drive fails, you can’t easily remove it to attach to a PC.

Symptoms of WD MyPassport Failure

  • LED constantly flashing / blinking
  • LED not lighting at all
  • Clicking / ticking noise
  • Disk is not formatted. Do you want to format it?
  • Unable to see your data in Windows or macOS
  • Unable to copy or read files

Troubleshooting Tips

If you have problems with a WD My Passport drive, you can make a few checks to see where the fault lies. Be aware that opening the external drive case will probably void your warranty. If there is important data on the drive you should seek professional data recovery advice before you try anything.

That’s the warning out the way, so lets have a look at some troubleshooting.

  • First check all cables are plugged in securely, and not damaged or frayed. If you have an identical spare cable you can try it, just be gentle
  • There is no point dismantling a WD MyPassport drive, as there is no SATA connection inside.
  • It’s worth trying the external drive on another computer. If it seems to work you should copy the data off straight away. The drive could still be faulty & fail again soon.
  • Whatever you do, don’t dismantle the actual hard drive. Hard drives are built in controlled clean-air environments and even the smallest spec of dust can cause permanent damage to the drive.
  • These external drives are quite unique in the way they work. It is not possible to replace the circuit board (PCB) on these disks, as your PCB contains important encryption keys. On the offchance that a replacement PCB worked, your data would be scrambled anyway without access to specialist decryption tools.

If you are looking for a data recovery service for your external hard drive have a look at our external drive recovery services.

Old Industrial Equipment Data Recovery

Old Industrial Equipment Data Recovery

It’s always interesting to see how a complex manufacturing line can be run from such old hardware. In this case we were sent a custom PC from a  machine that is used to fill and cap bottles.

The first problem was trying to get the case open to remove the hard drive. There is no ifixit guide for this thing!

Old Industrial Equipment Data Recovery
Old Industrial Equipment Data Recovery

Inside I found a 20GB Seagate laptop drive (dated 2007) running Windows 2000 along with the programs that control the machinery. The hard drive was connected to a proprietary motherboard that in turn connected to the machinery via serial ports.

In this case, data recovery was not enough. What the client needed was a full working copy of the failed disk to reinstall into the system. The aim was to get the kit up and running and return it to the customer so they could carry on with work as soon as possible.

We’re set up to handle exactly this sort of problem, so I got this recovered and returned within two days.

The Worst Head Crash Ever?

Worst Head Crash Ever
I’ve seen some pretty serious head crashes in my time. The worst part of my job is knowing I’ll have to tell someone their data is gone forever. Sometimes media damage can be subtle enough that it’s impossible difficult to even detect by eye. Other times the damage is obvious. Today was one of the clearest I’ve ever seen. What’s worse is that we got two of these identical disks from the same Mac Pro, with identical damage. You have to see it to believe it…
Worst Head Crash Ever?
Worst Head Crash Ever?
It’s difficult to know how long these damaged disks were left spinning, but it looks like months! If you look closely, you can see that the centre of the disk is worn right through. That black dust everywhere was once the shiny disk surface that stored the data. Nobody in the world can recover data from disk dust.
The easiest way to avoid such serious damage is to power off your hard drive as soon as you hear clicking. If we got these disks sooner it’s possible we could have recovered them.

Seagate Barracuda Ramp Weakness

Seagate Barracuda Ramp Weakness

During a recent RAID 5 recovery attempt, John made an interesting discovery inside the two failed disks. The plastic ramp that the heads park onto when idle had snapped in the same position on both drives. We don’t know if the heads got damaged first, and then broke the ramps during parking, or if the ramps broke first, damaging the heads as they parked. The client told us the disks were not dropped or jolted. Whatever the cause, both disks had scratches to the delicate magnetic surfaces. In this case, two failed disks from a four disk RAID 5 means the data recovery is not possible.

Old vs New

The other two disks in the RAID had different firmware and don’t show the same fault. We don’t know if these disks have the other (older?) more robust ramp system that we’ve seen in similar disks.

Seagate Barracuda Head Ramps
Seagate Barracuda Head Ramps

More Problems With Seagate Drives

These ramp problems are the latest in a long line of faults for Seagate.

Disk Info

Failed Disk Working Disk
Model Number ST3000DM001 ST3000DM001
PN 1CH166-306 1CH166-302
FW CC29 CC26
Date 14354 13407
Site Code TK TK

Interestingly, the surviving disks in this RAID array were dated 2013, and the failed disks 2014. I would have expected the older disks to fail first.

Seagate SSHD ST4000DX001 Data Recovery

I previously posted about a Seagate SSHD ST500LM000 hybrid hard drive which failed to spin. This hard drive was put into our R&D process due to the type of the failure and further analysis confirmed that the problem was relating to the Solid State part of the drive. At the time I had only seen this type of failure with the Seagate Thin SSHD laptop drives. But since then we have now received Seagate desktop SSHD hard drives with the same type of failure.

Because the SSHD hybrid drives are a cheaper option to SSD drives I am seeing more of them in for data recovery. Also as these are still mechanical hard drives, I am seeing many of the same failures as I do with standard hard drives. For example Electronic Faults, Dropped Drives, Water Damage etc.

ST4000DX001 Data Recovery

 

 

Top 3 Coffees in Portsmouth

Safe Data Recovery

It’s probably worth a quick explanation here. Why is this data recovery blog so interested in coffee? Well personally I love coffee, but I also often recover data from hard drives that have been for a drink (or a swim). So there’s my excuse, now back to the coffee!

Fortunately for caffeine addicts in Portsmouth like me, there are plenty of places to get your fix. I’m the sort of person that finds somewhere I like, and then just keeps going back there forever. Sometimes though, it’s worth having a look at the other options. My current top three places for coffee in Portsmouth are below in no particular order. I’ve chosen three, but I’m always happy to try more places so let me know if you’d like me to give your coffee a try!

Portsmouth Coffee

Coffee#1

Coffee#1 is a small chain of coffee shops spreading like wildfire from Wales, across the South West, all the way down to the South Coast of England. The local branch is in Palmerston Road, Southsea. They do great snacks, cakes & lunches (Sausage & Relish roll anyone?) I usually go for whatever single-origin coffee they have in, and I’m never disappointed. They also have beans & equipment for sale. I recommend the Brazillian beans if you can get them. They are my current favourite for grinding & Aeropressing at home. Visit the Coffee#1 Website

Home Coffee

I’ve only just found out about this place, but I’m so glad I did. I recently went for lunch here & had a big granary doorstep sandwich, an Americano, & an iced ring doughnut. I couldn’t have been happier with all those things.  The cosy shop on Albert Road is just a few steps away from the Kings Theatre, but they are set to open a new store on Cosham High Street, much closer to home for me! They have lots of info about their coffees on the blackboards and are more than happy to have a chat with you about brewing at home. They sell kit & beans too which is handy, although I’ve not tried the beans myself yet.(Update – The beans are great!) Visit the Home Coffee Website

Soprano’s

A bit of a wildcard entry here, and also a hearty recommendation if you like quality fresh Italian food. The Peroni on-tap is always delicious, and their after-dinner coffees are the perfect way to finish a meal. Booking is advised as the cosy restaurant is always bustling with customers whenever I’ve been there. Visit the Soprano’s Wesbite

So there you have my top three coffees in Portsmouth. If you’ve spilled coffee, or any other drink on your hard drive or computer, get in touch. We can help recover the data, and you can tell me if the coffee you spilled was any good!

Another Successful Dropped Hard Drive Recovery

No Chance Data Recovery

Last week I was working on another dropped hard drive recovery sent into us by one of our Data Recovery Partners. I immediately took the hard drive into our clean room and removed the top cover for internal inspection. Although the hard drive had been dropped there were no visible signs of physical media damage. I replaced the damaged internal heads, rebuilt the hard drive and successfully recovered the data for the customer and Partner.

Thankfully the partner had advised the customer to stop trying to access the hard drive as described in our blog. When they received the hard drive from the customer.  They sent it straight to us, without attempting anything themselves.
These actions by the customer and partner were critical in the eventual successful outcome.