Post reply

sql server 2005 & 2008 installtion Drive selection

  • September 1, 2010 at 4:33 am

    #141706

    Hi folks

    Please clarify this dought

    Sqlserver 2005/2008 s/w need to install only default drive (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL

    or

    can we install any other drives?

    if c:\ is must then what are the min services need to install

    if we want to install other than C:\drives(like D:\,E:\ etc.. what are the remaining serves need to install.

    Replies will be appriciated.

  • September 1, 2010 at 4:45 am

    #1214846

    the database engine and a lot of the support files must be installed on the %system% drive; after installation, you can move all the mdf/ldf files(alter database with move ) to a different drive, and i think a registry entry change can be made to define which folder path is used as the default for backups;

    so for a large portion of the installation, you can't move it to a different drive.

    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!

Viewing 2 posts - 1 through 1 (of 1 total)

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