Can I install SQL Express 2005 to C drive but store and run the database from a different partition on the same drive?
Thanks in advance.
Yes you can.
When installing from a command line, you can supply the INSTALLSQLDATADIR command to provide a non-default data location. You can also set this after SQL has been installed using the Database Properties tab of the Server Properties dialog.
Mike
