What Happened When I Didn’t Have Enough Disk Space to Install SQL 2012

November 7, 2016 | Views: 1161

Begin Learning Cyber Security for FREE Now!

FREE REGISTRATIONAlready a Member Login Here

 

Today I want to share with you a true story that happened to me last week. Although a bit off-topic, you might find it amusing, useful, and a real time saver in case you ever need to do the same thing.

When I bought my desktop PC last year, I purchased an SSD drive to use as the system drive (C:).

My First Mistake

At the time, the prices of SSD devices was pretty steep so although I had some doubts, I convinced myself that a 40GB drive should be more than enough to accommodate everything I need. That was big mistake #1.

As it turned out, the I-tunes backups of my iPhone, which (for some reason) can only be placed on “C:” already used 16GB. Now add to that my SQL Server installation, office and other essentials.

Most of these applications, even when installed to a different drive, still use up space on the system drive.  Soon I found myself struggling for space and using every trick in the book to free up as much space as possible on C: just to be able to work.

When I decided it was time to install SQL 2012 on the host O/S and stop using it in a VM, I realized that no tricks will help me now – I need a larger drive.

I happily went to my local hardware dealer and purchased a shiny new 128GB SSD. Since I didn’t want to install the O/S from scratch, I looked around for disk imaging software to clone my original disk onto the new drive. Should be simple right? I was about to find out the harsh reality soon enough.

I Find a Cloning Utility

A quick search on the internet revealed quite a few disk cloning utilities, some of them free, that claim to do the job. Some even had great reviews, so I quickly downloaded one, installed it and was extremely happy to receive the message “Disk Clone Completed Successfully.”

I changed the BIOS boot sequence, restarted the PC and received the cheerful message “BOOTMGR is missing.” I said OK, no harm done and quickly reverted the BIOS settings back, restarted the PC, and guess what – the same message again.

No worries. I booted into Windows recovery console which confirmed there is an issue with Windows start-up and suggested fixing it for me, which it did successfully. Booting back from my original drive succeeded and a quick look into Windows logs revealed that Windows blocked the cloning utility from gaining access to the boot sector.

So much for “Successful cloning” within Windows.

Cloning Outside Windows

I didn’t give up. If I can’t clone from within windows, I surely can clone from outside windows, right? I downloaded a fantastic boot disk (UBCD) pre-installed with many disk utilities, booted into its Windows XP PE (Pre-Installation) environment and it happily cloned the disk for me, this time successfully (or so I thought).

I removed the old disk and plugged in the cloned copy in its place. I restarted the PC, and now it just hung after the BIOS messages with a small blinking cursor at the top- left corner of the screen. No worries and no harm was done. I have the magical windows recovery console which worked great last time!

I placed the Windows DVD back in the drive, rebooted and indeed it again found a problem with Windows start-up. I clicked “Repair” and got the message “successfully repaired your Windows installation.”

I rebooted again, and my old friend, the top- left blinking cursor appeared again, and the PC just hung.

No worries! I quickly plugged the old disk back in and moved the new disk to another slot, then rebooted again. This time, Windows boot menu appeared and now I had not one, but 2 “Windows 7 Ultimate” installations from which I was asked to choose. However, this time both of them worked. One booted from the old disk and one from the new one.

But now I encountered a new issue.

A New Problem 

No matter which one I booted, the new drive was labeled as “E:” and not “C:,” worse than that, the 128GB disk was identified by disk manager as having just 40GB although its hardware properties showed the correct size.

Trying to extend the partition was strictly refused by windows with the very informative error message “Parameter is incorrect.”

After a few futile attempts to get this configuration working using some scary utilities to modify internal disk properties, and as I was about to give up about 4 hours into the job, I gathered my strength again and decided to try a different approach.

I realized that Windows 7 has a built- in imaging utility for disaster recovery that should be able to do the trick.

On we go.

I deleted the partition from the new disk, booted again only to find out windows still thinks I have two operating systems. In the old days, we had boot.ini which could be manually edited, but it’s no longer there in Windows 7.

Sigh, take a deep breath – I can live with that. Windows was more than happy to create an image for me (note that you must have a 3rd drive to store the image on).  I removed the old disk, plugged in the new one, booted again into windows recovery console. When I was asked to restore an image, it searched the disks for me, found my recent image and suggested to restore it.

Delighted, I clicked “YES!” please restore my system on the new drive, only to receive a new error message: “no suitable disk found to restore the image on.”

I checked again, the new disk was identified correctly by the BIOS, and even by Windows itself in the “exclude disks” list. So why won’t it restore the image on it???

Things Get Frustrating

At this point, I was pulling my hair out (and I don’t have much of it…), but I didn’t give up. I remembered my wonderful boot disk with all its low- level disk utilities, it must find if there is something wrong with it.

Again I booted into Windows PE and tried ALL available diagnostics on it. Nothing was found wrong. I used everything I could think of – removing MBR, wiping the disk clean with every possible utility but to no avail. Windows just decided it doesn’t like my new disk and won’t restore the image on it.

I was just about ready to bite the bullet and re-install windows from scratch when I remembered that windows recovery console comes with a partition utility of its own called “Diskpart.”

As a last resort, I tried it.

Diskpart Does the Trick

SELECT disk 0 (yes – that’s diskpart language) followed by a CLEAN command finally did the trick. I rebooted, Windows agreed to recognize the new disk, restore the image on it and even agreed to extend the partition to the full 128GB.

At last, I have my old O/S, running on the new disk and utilizing its full capacity. Yes, there still were some minor “leftover” issues and errors but nothing that I can’t live with.

All in all, it took more than 7 hours of work and a lot of frustration to make this work. I was also glad that I bought a heavy duty PC case which only suffered minor “frustration dents” in the process 🙂

BTW – I also managed to fix the boot menu issues with this cool boot manager (free for personal use) from http://neosmart.net/EasyBCD/

In Conclusion

So to sum up my lessons from this experience:

  • Don’t convince yourself that the cheaper hardware will do when you suspect it might not. It will eventually cost you much more.
  • Don’t use cloning utilities to move operating systems – use the native Windows imaging.
  • Don’t use 3rd party disk partitioning utilities as windows doesn’t seem to like them – use diskpart instead.

If you ever need to move your operating system from one disk to another, take a day off 🙂

Share with Friends
FacebookTwitterLinkedInEmail
Use Cybytes and
Tip the Author!
Join
Share with Friends
FacebookTwitterLinkedInEmail
Ready to share your knowledge and expertise?
5 Comments
  1. let me laugh for few hours and then we will get back on this.;)
    cheers mate

  2. Trying to extend the partition was strictly refused by windows with the very informative error message “Parameter is incorrect.”

    Informative as always, right? XD

  3. “I was also glad that I bought a heavy duty PC case which only suffered minor “frustration dents” in the process” 😀 😀 😀
    Love it! 😉

  4. What an exprience !

  5. That is a sad story, that at least has a happy ending. I don’t use the built in Windows imaging tools anymore, as I’ve had the exact opposite experience. For years I used Partition Saving from the UBCD, but the last few years I’ve been using Clonezilla for all my imaging needs. It’s on the Parted Magic CD, which is an option on the latest version of UBCD. I’ve also moved away from the UBCD as Parted Magic handles everything I need to do now.

    Thanks again for the story it was good read.

Comment on This

You must be logged in to post a comment.

Our Revolution

We believe Cyber Security training should be free, for everyone, FOREVER. Everyone, everywhere, deserves the OPPORTUNITY to learn, begin and grow a career in this fascinating field. Therefore, Cybrary is a free community where people, companies and training come together to give everyone the ability to collaborate in an open source way that is revolutionizing the cyber security educational experience.

Support Cybrary

Donate Here to Get This Month's Donor Badge

 
Skip to toolbar

We recommend always using caution when following any link

Are you sure you want to continue?

Continue
Cancel