Post reply

(How-To) Installing MSSQL2005 in a different location

  • October 30, 2008 at 5:02 am

    #127332

    I'm installing MSSQL 2005 from the full featured demo install (our logistics department is in the process of ordering 2 licenses for 2 production servers). Of course, the demo server is good for 180 days but I'm told the license can be applied to the demo installation when it arrives.

    Here's my newbie How-To question, I have run the install twice (uninstalled once obviously) on our M5 server because the network admins installed the server on the C: partition of the server, I want it installed on the D: partition. The difference between the two partitions is only space; C: has 17GBs and D: has 182 GBs.

    Each time I have run the setup I haven't been to find the place to change the installation directory, yet, there must be a place because the network admins where able to get the installation on the D: partition for M6.

    How do you change the install directory?

    Thanks!!!!

  • October 30, 2008 at 5:29 am

    #891687

    In the setup, where you select the components you want installed, the install path is changeable down the bottom. You can also specify to put the data files in a different location to the SQL server install if you wish.

  • October 30, 2008 at 7:13 am

    #891740

    I think you can install SQL in C drive and save the data (mdf) file and log (ldf) file in D drive.

  • October 30, 2008 at 7:50 am

    #891785

    You can install SQL anywhere (the program files) and set the data files anywhere as well. You can move data files (detach/attach), set defaults for new databases, or ad hoc, create mdf/ndf/ldf files on any disk attached to your server.

  • October 30, 2008 at 9:32 am

    #891907

    HI, you can install sql server anyware, the standard is in C: drive, the database files by default go to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.

    You can change default folder in Sql Server Management Studio connect to a server and rigth click server and go to properties

    In database settings you have the database default locations

    Hope it helps 🙂

  • October 30, 2008 at 11:29 am

    #892006

    Just install it at the default location and save the space on the D:\ drive for the data and log files.

  • October 30, 2008 at 12:44 pm

    #892044

    Thanks to everyone! I found that 'Bowse' button next to the install path, it was easy -- I feel a little stupid, because I was lookng for a textbox with a button and an ellispe in it...geez...

    Thanks again!

Viewing 7 posts - 1 through 6 (of 6 total)

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