Suggestions to install SQL express edition at Database Engine configuration window

[genesis]

Hi

 

We are going to implement new Cashless catering system. The Company who is going to implement has asked me to build a server with the following server specification the given spec as follows.

Hardware

- C: Main Drive: for OS: 40-60GB

- E: Secondary Drive 160GB / For Software, sqlData and sql logs

 

Operating System & Software

- Windows Server 2012

- SQL Server Express 2014 (Express has a 10GB Limit)

 

From the above hardware requirement, it says Main Drive C: for OS: 40-60GB

and E secondary drive for Software, sqlData and sql logs.

 

Please see the attached snapshot and I am stuck on the Database engine configuration window. Here do i need to leave to the default installation directory C: OR do i need to change the default path from C: to new path on E: as shown below.

User database directory :E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data

User Database log directory:E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data

Temp DB directory:E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data

Temp DB log directory:E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data

Backup directory:E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup

 

 

 

Please suggest , Any help will be great

Thanks

[genesis]

On the first "Feature selection windows" for Instance root directory, Shared feature directory and Shared feature directory(x86)

I have chosen the default path as C:

[theriver]

I'd drop it all into E:, that way you keep as much as possible off of c: (which at 40Gb will appear quite full anyway) and the installer takes care of setting up everything in a useful location with the right permissions etc.

[TwistedHelixis]

Definitely put everything on D. I would go for 60gb min on C - who knows what size windows updates will need over the years.