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.

Common Applications We Recover SQL From

  • Web server MySQL, PostgreSQL
  • Windows Application MSSQL

Why Cloud Backup Is Not Enough

Why Cloud Backup Is Not Enough

If you have a computer, tablet, or mobile you most likely have some of your data stored in the cloud. It may just be syncing your contacts or calendar, or even backing up your photos from your iPhone or Android phone. Whatever the reason it is now a cheap way of keeping your data safe. Or is it?

Never take for granted that your data is getting backed up correctly. Check it yourself.

I had a situation just recently where my wife’s iPhone had just gone through a 60℃ wash.

“That’s okay,” I said,  “We have all your data on iCloud…”

A few days later we replaced the phone (thanks insurance) and restored the data back from iCloud.  That’s when we discovered iCloud hadn’t been copying Contacts and some other data. Fortunately I had  also kept another backup using iTunes on my Mac so was able to restore from there.

Now would be a great time to check your iCloud settings and make sure there’s a green tick next to everything you don’t want to lose!

Another thing to look out for, especially if you have a lot of data, is your upload speed. Unless you have fast broadband,  uploading large amounts of data can take time. You’re unprotected until all of the data has reached the cloud. In some cases it can take hours, even days, depending on how much data you have and the speed of your network.

Once you have uploaded all your data, your device will only need to copy new changes so won’t take so long. As a Plan-B, don’t forget to backup to a computer once in a while. You can thank me later.

Don’t leave it until it is too late. You never know when your phone will take a spin in the washing machine.

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.

eBay Fake Capacity USB Sticks

Despite some amount of publicity, the problem of fake capacity flash drives being sold online has still not gone away. Recently we did a bit of consumer investigation and bought a few to test. Surely after two or three years eBay will have sorted this problem out?

eBay Fake Capacity USB Sticks

What Are Fake Capacity Flash Drives?

If you’ve not heard of these before, a fake capacity flash drive is simply a small low capacity flash drive pretending to have (much) more storage. The clever / devious part is that they may have only 16GB of real storage, but can appear to the computer as anything up to 2TB. You will be able to copy data to the device, but only the first 16GB may be readable later. Some devices constantly overwrite the same 16GB while other just dump the rest of the data into a back hole.

How Do I Know If My USB Drive is Fake?

There are not any strict rules, but you can start to build up a picture as you gather more information.

  1. Price – These flash drives will be WAY cheaper than anything you can buy in a retail store. We just bought 512GB flash drives for £10 and 1TB drives for £15. Currently a 64GB SD card is £32.48 at Novatech, so you can see how expensive real flash drives should be.
  2. Quality – Large capacity USB drives are relatively expensive. You’d expect them to be well made and probably well packaged. The fake drives usually come unbranded, in generic clear bags.
  3. Wording – Since these problems have been reported, some sellers are putting some disclaimers on the listings to suggest you should only use the devices for small amounts of data etc. This is obviously nonsense. If you buy a real 1TB of storage, you can use all 1TB.
  4. Testing – Although most people won’t be familiar with testing hardware, there are some pretty simple tools to test USB drives. They write patterns of data to the chosen device and then read it back again to make sure it was written correctly. USB Test Tool (It’s German, but also runs in English)

What To Do If You Have A Fake Capacity Flash Drive

Most online marketplaces like eBay have pretty robust buyer protection to allow you to claim a refund. The advice for making claims varies with each website so you may need to hunt around, or contact the site directly. Although eBay are more than happy to organise refunds, they show little interest in stopping the sale of these devices. We’ve spoken to eBay customer services a number of times and they said that their system will flag up if enough people make returns.

USB Stick

You Often Don’t Know Until It’s Too Late

It’s a bad idea to keep using one of these USBs. If you detect a fake capacity, you may think it’s OK to just use it for small amounts of data but it’s not a good idea. The problem is that as you use and delete files, you could gradually start edging towards the limit of the storage. The next file you write could just go into the black hole, and the data is lost. In fact, many people don’t realise their flash drive is a fake until they exceed the “genuine” part of the storage. If you were copying photographs to the USB drive, you might not notice that some of them are missing until you try to read them again much later.

Not Just Memory Sticks

These same types of fake flash drives also appear as SD cards so we’ve heard from people that were at weddings or on their honeymoon and lost all or most of the photos.

Fake eBay USB Drive Animation

Update 31-10-2016: Since posting this, we were made aware of this report from the USA about eBay’s problem with fake flash storage.

SandForce SSD Data Recovery Problems

Mac Pro SSD

The low prices and high speed access of the Sandforce controller made it an appealing option for SSD manufacturers such as Toshiba, Intel, Kingston & OCX. But it soon became a problem for users when the SSD devices using these controllers started to fail in their computers after just six months of use. Usually it resulted in the device not being recognised by the computer bios, and not functioning at all.

That was okay if you were happy to have it replaced under warranty by the manufacturer. The problem came when you wished to try and recover critical data that may have been stored on these SSD’s. The use of full hardware encryption on the controller and the device, meant that the data could not be recovered, even when using low level data chip removal.

Fortunately today these controllers are not so popular, and as a result most mainstream manufacturers do not use them. But be aware that they can still be found in some non branded SSD’s.