First time i have touched sql 2005, I have installed onto one drive in our test enviroment (we only had one drive) and worked fine.
i have installed in our live environment successfully, but I want to to move the temp.mdf and temp.log off the C: partiton to D: for the DATa and L: for the Logs.
I tried to detach ie single user etc, but the error i get it is that it is a system database and cannot be detached.
we are curently not running anything on this server, it is a 64 bit install.
any suggestion, its temp database I really want to move.