Wednesday, March 28, 2012

Install on D drive

Is there a way to install SQL 2005 Express on a different drive? The server that I want to use has 700MB availible on the C drive and 80 GB availible on the D drive. can I install SQL and all tools on the D drive?

hi,

when running the setup in "wizard" mode, uncheck the "hide advanced configuration options" check box..
in the "Features selection" wizard task, modify via the "browse" button the drive/folder locations of the "Database Services" and "Data Files" as required..

if you are running setup in "command" mode, provide the INSTALLSQLDIR and INSTALLSQLDATADIR parameters accordingly to your needs..

regards

|||

Will this work with the tools? When we installed the tools on a different machine, it did not give us an option. I was able to get SQL on the other drive.

Thanks

|||

hi,

the "tools", SQL Server Management Express does not seems to provide this feature as well... but, if you install SQL Server Express with Advanced Services, which includes SSMSE, you should be able to designate an alternate location for it as well..
please consider that a "minimal" part of the binaries, the "shared" one, that's to say the part of the binaries shared among all instances will be installed in the \Program Files\ hyerarchy...

regards

No comments:

Post a Comment