June 5, 2009 at 1:54 am
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 ?
June 5, 2009 at 2:37 am
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