How can I set "Database Default Location" during unattended sql server installation

• egpotus

  SSCommitted

  Points: 1654

  More actions

  April 16, 2009 at 2:26 am

  #208258

  hi,

  Is there a way to set "Database Default Location" during unattended sql server installation ?

  (Database Default location can be displayed in "Database settings" in Server Properties)

  ---

  Kindest Regards,

  egpotus DBA
  

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  April 16, 2009 at 2:57 am

  #978661

  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]

• egpotus

  SSCommitted

  Points: 1654

  More actions

  April 16, 2009 at 3:10 am

  #978665

  thank you

  ---

  Kindest Regards,

  egpotus DBA