We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

ironryan77
ironryan77 asked
on
Medium Priority
1,127 Views
Last Modified: 2012-05-11
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?
Comment
Watch Question

Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
It is not possible to istall whole setup on external drive. Some of the require component of SQL always install on System Drive.

Commented:
you can not run a full installation od sql server on an external driver.

Author

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?
CERTIFIED EXPERT

Commented:
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.....

Author

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!
Sr. BI  Developer
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks!
CERTIFIED EXPERT

Commented:
That's it.. I was just referring to virtual PC from Microsoft which is also free.


Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.