Where should SQL Server Binaries be installed on windows server
0
votes
1
answer
243
views
Is there a best practice on where to install SQL Server binaries for a new windows server deployment. I've seen some people suggest that it's best to seperate this from the OS drive and place it on it's own drive. I've seen others seperate it from the OS and place it on the same drive as the database file, and now while reading through the Architecting Microsoft SQL Server on VMWare vSphere the document says:
> The SQL Server binaries should be installed in the OS VMDK. SQL
> Server, even if another drive is selected for binary installation,
> will still install things on the OS drive so there is no real point
> in installing elsewhere
I get the need to setup database, transaction logs, tempdb and backups each on their own drive and the reasons for these recommendations, however I'm not 100% sure on the best practice recommendation on where to install the SQL Server binaries and why, especially since i've seen various recommendations from trusted sources.
For our application, this will be a virtuallized server on vmware.
Asked by John-Rock Bilodeau
(113 rep)
Oct 19, 2023, 06:26 PM
Last activity: Oct 20, 2023, 01:14 PM
Last activity: Oct 20, 2023, 01:14 PM