Installation Directories Folder

  • Just a question on an installation as I need to split out the binaries and system databases. I am right in thinking that the instance root directory (instance configuration screen) is for the binaries and the data root directory (data directories) is where I can point the system databases?

    Also, would the data root directory allow me to configure the location for SQL Agent?

    Cheers!

  • I am right in thinking that the instance root directory (instance configuration screen) is for the binaries and the data root directory (data directories) is where I can point the system databases?

    Correct.

    Also, would the data root directory allow me to configure the location for SQL Agent?

    I don't know any way to move specific binaries to a different directory, nor see the need for such an operation.

    What are you trying to achieve?

    -- Gianluca Sartori

  • Thanks

    Its a rather rigid setup process and I'm a relatively new sql person so just wanting to ensure the servers match up to how they have been previously and we have specific volumes for the system db's and binaries and I couldnt see in the installation guide how to actually specify locations for them!!

  • The setup process lets you choose specific locations just for tempdb. If you want to move the system databases in a specific folder, you can do it after the setup is finished. Or, leave them where the setup puts them and specify a different location for the user databases.

    -- Gianluca Sartori

  • thanks, with that in mind - what are the instance root directory and data root directory paths for in the setup process?

  • instance root directory = binaries

    data root directory = root for other directories, such as default data folder, default log folder and other folders (logs et similia)

    -- Gianluca Sartori

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

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