April 16, 2009 at 2:26 am
April 16, 2009 at 2:57 am
You have to use the INSTALLSQLDATADIR parameter. Problem is that this will only accept one directory for data and log files.
In case you want to have separate loctions for data and log I would advise run a post install script.
For Datafiles:
EXEC master..xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData', REG_SZ,'D:\MSSQL.1\MSSQL\DATA\'
For Logfiles:
EXEC master..xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',N'DefaultLog', REG_SZ,'E:\MSSQL.1\MSSQL\LOG\'
[font="Verdana"]Markus Bohse[/font]
April 16, 2009 at 3:10 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy