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?