SQL 2008 installation

  • I am doing an unattended installtion of SQLServer 2008 using values set in a configuration file. What i observe is DATA folder and its datafiles like .mdf, .ldf etc all go under installation folder itself. Like C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA.

    But i want MSSQL10.MSSQLSERVER\MSSQL\DATA folder in a different drive, say D drive. In the config file there is a parameter called INSTALLSHAREDDIR which i have set to D:\. But when run, i still see the folders under C:\Program Files\Microsoft SQL Server only.

    Basically, i want to maintain all the folders like Backup, Binn, Data, Log, Jobs etc.. in a different folder.

    So, is there anything that i need to set anywhere ?

  • You used the wrong parameter. Use /USESYSDB, /SQLUSERDBDIR and /SQLUSERDBLOGDIR.

    For more info see http://msdn.microsoft.com/en-us/library/ms144259.aspx

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply