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?
ironryan77Asked:
Who is Participating?
 
Jason Yousef, MSConnect With a Mentor Sr. 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
 
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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
 
ironryan77Author Commented:
Thanks!
0
 
p_nutsCommented:
That's it.. I was just referring to virtual PC from Microsoft which is also free.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.