Friday, February 10, 2012

Can I install to C and put data on E?

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

No comments:

Post a Comment