Microsoft SQL 2019 install using more than drive c

brian w 1 Reputation point
2022-10-28T22:56:54.957+00:00

I am trying to install SQL Server 2019 standard on a client's machine. Thing is, the machine has a boot SSD and a raid 5 array. I believe I need to install the actual program in c:\program files or something like that, but I would like to use the raid array as much as possible. The eval versions I can download have a very different install routine so that does not help. I am basically expecting to install the program on the boot drive but am hoping to put the database and as many of the extras on a different drive. How is this possible?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,139 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Ronen Ariely 15,091 Reputation points
    2022-10-29T08:25:25.043+00:00

    Hi,

    I am basically expecting to install the program on the boot drive but am hoping to put the database and as many of the extras on a different drive. How is this possible?

    While you install SQL Server, you have options to select where your databases will be stored by default (including the system databases). Check the image of step 12 in the following tutorial:

    https://computingforgeeks.com/install-sql-server-developer-edition-on-windows-server/

    In any way, you can always configure the locations of database's files after the installation for example while creating the files.

    0 comments No comments

  2. CathyJi-MSFT 21,116 Reputation points Microsoft Vendor
    2022-10-31T03:24:55.447+00:00

    Hi @brian w ,

    You can set this during the installation as below screenshot. You can change the location to put data \log files or backup files.
    255522-capture.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments