Post reply

drive to install sql server

  • February 26, 2011 at 3:52 pm

    #148483

    When installing SQL server, my plan is to put data file on one drive, log file on another, backup on the third drive. My question is about where is the best option, should I install SQL server, on C drive, or on a different drive to leave C only to operating system?

    Thanks

  • February 26, 2011 at 8:45 pm

    #1291968

    for the executable and services, you don't have a choice...it must be installed on the same drive as the operating system.

    after the install, you can move most of the databases to other drives.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 27, 2011 at 4:21 am

    #1292019

    I install sql server on D drive. The company I work for doesn't provide a C drive with much space so we install all software on D drive (all software... litespeed, sql server, ssh/sftp, ndm, teradata connectivity software, oracle connectivity software...etc. etc. all goes on D drive).

    I always create 2 data files (1 mdf, 1 ndf). I keep the mdf small (I limit it to 5GB max) and allow all ndf files to grow (none of my databases are small). I put log and index files on different drives as well. Better to spread them out among drives if you have the drives.

  • February 28, 2011 at 4:04 am

    #1292216

    Hi,

    We are following policy not to install any software in the Operating System drive (which is generally C:\ drive).

    Also for SQL Server, we placed datafiles / log files / backup files in the different drives (recommended).

    `If not, you can place datafiles and log files in different path then others files can be clubbed along with these two files.

  • February 28, 2011 at 9:57 am

    #1292418

    As Lowell mentioned, for the executable and services, you don't have a choice. However, during the installation process, when you get to the step regarding file location, this is where you can map the default location for the database files. By performing this step during the initial installation you don't have to make a note down the road on every database create to make the modification, or the registry change to make it global.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

Viewing 5 posts - 1 through 4 (of 4 total)

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