November 5, 2018 at 9:58 am
Is there a way to change system msdb and model databases from their default location during the install? I know you can change the data root directory but that also puts a lot of other stuff in the directory that I do not want with the databases
November 5, 2018 at 12:54 pm
I would expect if you launch the install from the command line, you ought to be able to specify the location for the system databases. Seeing as it looks like the switches haven't changed since I did a SQL 2014 install:
/INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server"
/INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server"
/INSTANCEDIR="D:\Program Files\Microsoft SQL Server"
/INSTALLSQLDATADIR="System databases and logs go here"
/SQLBACKUPDIR="Default backup directory here"
/SQLUSERDBDIR="User database MDFs here"
/SQLUSERDBLOGDIR="User database LDFs here"
/SQLTEMPDBDIR="TempDB MDFs"
/SQLTEMPDBLOGDIR="TempDB LDFs"
The link below is to the MS documentation on this, you should be able to work from that to build up your CMD line.
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-2017
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply