[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 786
  • Last Modified:

How do I install SQL Server 2008 on an external USB hard drive?

I just bought an external USB drive to hookup to my Windows XP SP3 laptop.  I connected my laptop to this drive and I tried to install SQL Server on it.  However, I was only able to specify part of the installation on this external drive.  

But the other part of the installation remained on the C drive.  I don't see a way to change this for some of these files.  Is there a way to install 100% of a new SQL Server 2008 program on an external hard drive?  If so, how can I do this?
0
ironryan77
Asked:
ironryan77
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
It is not possible to istall whole setup on external drive. Some of the require component of SQL always install on System Drive.
0
 
tigin44Commented:
you can not run a full installation od sql server on an external driver.
0
 
ironryan77Author Commented:
Can I run at least PART of the installation on an external drive?  What if I set up an OS on this external drive.  Then can I set up the full install on it?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
p_nutsCommented:
Only if you boot from it.. I think its going to be easier to install a virtual machine and run it in there..  I am assuming  it won't be a production system running SQL server on XP.....

0
 
ironryan77Author Commented:
@pnuts, can you explain more?  What do u mean by install a VM?  On the external hard drive?  And then run Wiindows XP in there?  If you could explain more of the specifics that would be terrific!
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
You can use something like that...it's free and tested before
http://www.nu2.nu/pebuilder/

or install http://www.virtualbox.org/ and create a virtual machine, when you're asked where to keep the data file (virtual hard disk) , just point to your USB.

steps are here...
http://www.ghacks.net/2009/06/15/installing-a-windows-xp-as-a-virtual-machine-on-virtualbox/

Have fun.....
0
 
ironryan77Author Commented:
Thanks!
0
 
p_nutsCommented:
That's it.. I was just referring to virtual PC from Microsoft which is also free.


0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now