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.

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.

APFS Data Recovery

When Apple release the latest version of macOS (named Sierra) in Autumn, it will include the new APFS filesystem. Apple haven’t launched a new FS for a long time, and this filesystem won’t work for bootable disks at first. Eventually Apple will make this the default filesystem across the whole product line, from the iPhone, through to the Mac.

APFS Data Recovery
APFS Data Recovery

APFS Upgrade In Place

I have heard that Apple will release a tool to upgrade an existing HFS+ volume to APFS. If you run the upgrade I strongly advise you to make at least a couple of backups first. I would suggest a Time Machine backup and a bootable full disk copy, with online backup if you have it. While the upgrade is cleverly designed to minimise the risk of disk corruption, there is always the chance that failure could leave you with no option but wipe & start again. This is especially true of older Macs that you may have updated through multiple OS versions and accumulated all sorts of nasties along the way.

APFS Data Recovery

We are already working through the APFS documentation to keep ahead of these failures. We will have some recovery tools ready soon. As with most recoveries, the most important thing is to stop as soon as you hit a problem. Remember my new catchphrase, “Most damage to data happens AFTER the original failure!” Or, “It’s not the failure that killed the data, but the failed repair.” (I know, snappy right.)

If you’ve lost data from an APFS disk, contact us now, or have a look at our Mac Recovery Services for more info.

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!

Free Data Recovery

Hard Drive Data Recovery

Despite offering world-class data recovery from our workshop here in Portsmouth, we understand that sometimes, the data just doesn’t justify the cost of getting it recovered. If you’re going to go it alone and attempt a DIY recovery, we’ve got some handy tips to avoid making things worse. It might be a good idea to print this page to use as a reference. Also feel free to comment at the end of the post if you’d like any questions answered.

Stop Using Your Hard Drive

If you want to recover data, you can’t do it from the disk you want to recover from. When you boot up a computer it writes data to the hard drive. Even browsing the web or checking e-mails writes little cache files to the disk, potentially overwriting the files you want to recover.

Set Up

You ideally want to work from a different and reliable computer, have plenty of storage space for recovered files, and make sure everything is ready before you attach the faulty disk. You don’t always get a second chance with hard disks, so make sure you’re ready to grab the files if they appear.

Now You See Them

If you suddenly gain access to the files, copy them to another drive as soon as you can. The disk is unlikely to have repaired itself, so this might be the last chance to copy the data before if gives up completely. Take the most important files first. If the copy gets stuck, stop it straight away as the disk could be causing damage.

Watch The Clock

If you decide to try DIY recovery, keep a close eye on the time. If the estimated time keeps increasing it could be a sign of disk trouble. Failure to deal with that could cause the drive to fail completely, and beyond repair (even for us). As a guideline, it should take no longer than a few hours to copy a whole 1TB disk over USB 3.0. If your estimate says much more than that, or keeps going up in time, it could be the disk getting worse. Maybe try copying important files in small batches first. Data Recovery Time Remaining

Priorities

Your priority with a failed drive is either to make a copy of the disk, or copy off the files as soon as possible. Don’t try to scan, repair or fix any errors. A failed repair can completely damage your files beyond recovery. This means don’t ever use spinrite, diskwarrior, techtool, or any other diagnostic tool until after you’ve extracted the data. Some people report success with these tools, but it’s far safer to copy the data first, and run those tools later.

Restore or Reinstall?

Don’t re-install or restore the computer. At best it will overwrite some of the data. At worst it will overwrite all of the data and leave you with a factory-fresh (blank) version of Windows. If you’ve already done this, we can often get data back, but it won’t be as complete as a normal recovery.

Brrrr It’s Cold in Here

Never ever put a hard drive in the freezer. Although this trick is a common part of data recovery folklore, it is likely to do so much more damage than good. We have never used any type of freezing process for data recovery, and neither should you. Leaving your hard disk unplugged for a day is likely to be just as successful, and won’t risk contaminating the delicate disks and heads. Hard disks are not air-sealed so even if you put them in a sealed bag, they already have moist air inside them which can freeze and then cause condensation.

Stop Hitting Yourself

If you saw how delicate the inside of a hard disk was, you’d never consider hitting, tapping or knocking it. Even if you did manage to dislodge some stuck heads, you’ll probably either rip them off, or take a chunk of the disk with it. There are careful ways to remove stuck heads, but they cannot be done at home.

Keep it Together

Never dismantle a hard drive. This is a case when the “no user serviceable parts” label really is true. Not only are disk internals extremely delicate, they have an air filter in the cover to stop particles getting inside the disk. If you remove the cover, all sorts of dust and lint can get in. Dust particles are bigger than the gap between heads & disks, so they can cause the heads to crash into the disks and scrape off the magnetic coating. Once the coating is gone, the data is gone.

Good Luck

If you decide to try DIY data recovery, good luck, and be careful. If you’d rather let us look at the disk instead, get in touch.