Share via

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,366 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,186 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
  2. CathyJi-MSFT 21,136 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