Hi there,

I'm installing SQL server 2005 and I need to modify the database default
location for Data and Logs folders during the setup process but I don't find
the place to do it.

I've searched on the internet but didn't find the information I need to get
my job done.

Can you me with that please?

Many thanks

Jack

Hello,

Alter the SQL Server intallation go to SQL Server management studio -
connect to the database server-- right click above the server name and click
properties.
After that go to database setttings tab-- there change the data and log
locations and click OK.

THanks
Hari


"Jacques" <JBouchard@compugen.com> wrote in message
news:%2331WZwOjHHA.1220@TK2MSFTNGP03.phx.gbl...
> Hi there,
>
> I'm installing SQL server 2005 and I need to modify the database default
> location for Data and Logs folders during the setup process but I don't
> find the place to do it.
>
> I've searched on the internet but didn't find the information I need to
> get my job done.
>
> Can you me with that please?
>
> Many thanks
>
> Jack
>

Hello Hari,

Thanks for your answer. I need to do it when installing SQL 2005. The
process will be automated and it will be difficult to do after the
installation.

Is there a way to do it during the installation?

Thank you very much for your time!

Jack

================================================== ========================

"Hari Prasad" <hari_prasad_k@hotmail.com> a écrit dans le message de news:
%23Djr$rSjHHA.2120@TK2MSFTNGP03.phx.gbl...

> Hello,
>
> Alter the SQL Server intallation go to SQL Server management studio -
> connect to the database server-- right click above the server name and
> click properties.
> After that go to database setttings tab-- there change the data and log
> locations and click OK.
>
> THanks
> Hari
>
>
> "Jacques" <JBouchard@compugen.com> wrote in message
> news:%2331WZwOjHHA.1220@TK2MSFTNGP03.phx.gbl...
>> Hi there,
>>
>> I'm installing SQL server 2005 and I need to modify the database default
>> location for Data and Logs folders during the setup process but I don't
>> find the place to do it.
>>
>> I've searched on the internet but didn't find the information I need to
>> get my job done.
>>
>> Can you me with that please?
>>
>> Many thanks
>>
>> Jack
>>
>
>

Though I haven't tried this, I think you can do this with a template file
and a command line installation. The command line install is discussed in
the Books Online topic How to: Install SQL Server from the Command Prompt. I
see that the template.ini file has an option called INSTALLSQLSHAREDDIR. It
looks like you can specify:
INSTALLSQLSHAREDDIR=D:\xyz\abc\

The description says:
; INSTALLSQLDATADIR specifies the location for the SQL Server data files.
; Default: INSTALLSQLDIR\Data\
; To use the default path, do not specify the following parameter.

; NOTE: INSTALLSQLDATADIR is REQUIRED for clustered installations and must
point to a
; shared drive which is a member of the cluster group specified for
installation.
; NOTE: If there is a space in a specified path, surround the path with
quotes
; and end every path with a '\'.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jacques" <JBouchard@compugen.com> wrote in message
news:eoFBloXjHHA.3940@TK2MSFTNGP02.phx.gbl...
> Hello Hari,
>
> Thanks for your answer. I need to do it when installing SQL 2005. The
> process will be automated and it will be difficult to do after the
> installation.
>
> Is there a way to do it during the installation?
>
> Thank you very much for your time!
>
> Jack
>
> ================================================== ========================
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> a écrit dans le message de news:
> %23Djr$rSjHHA.2120@TK2MSFTNGP03.phx.gbl...
>
>> Hello,
>>
>> Alter the SQL Server intallation go to SQL Server management studio -
>> connect to the database server-- right click above the server name and
>> click properties.
>> After that go to database setttings tab-- there change the data and log
>> locations and click OK.
>>
>> THanks
>> Hari
>>
>>
>> "Jacques" <JBouchard@compugen.com> wrote in message
>> news:%2331WZwOjHHA.1220@TK2MSFTNGP03.phx.gbl...
>>> Hi there,
>>>
>>> I'm installing SQL server 2005 and I need to modify the database default
>>> location for Data and Logs folders during the setup process but I don't
>>> find the place to do it.
>>>
>>> I've searched on the internet but didn't find the information I need to
>>> get my job done.
>>>
>>> Can you me with that please?
>>>
>>> Many thanks
>>>
>>> Jack
>>>
>>
>>
>
>

Thank you very much for your quick answer!

I will take a closer look at it.





"Rick Byham, (MSFT)" <rickbyh@REDMOND.CORP.MICROSOFT.COM> a écrit dans le
message de news: 34E98E85-7641-435E-BC24-A4786228BDB7@microsoft.com...
> Though I haven't tried this, I think you can do this with a template file
> and a command line installation. The command line install is discussed in
> the Books Online topic How to: Install SQL Server from the Command Prompt.
> I see that the template.ini file has an option called INSTALLSQLSHAREDDIR.
> It looks like you can specify:
> INSTALLSQLSHAREDDIR=D:\xyz\abc\
>
> The description says:
> ; INSTALLSQLDATADIR specifies the location for the SQL Server data files.
> ; Default: INSTALLSQLDIR\Data\
> ; To use the default path, do not specify the following parameter.
>
> ; NOTE: INSTALLSQLDATADIR is REQUIRED for clustered installations and must
> point to a
> ; shared drive which is a member of the cluster group specified for
> installation.
> ; NOTE: If there is a space in a specified path, surround the path with
> quotes
> ; and end every path with a '\'.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jacques" <JBouchard@compugen.com> wrote in message
> news:eoFBloXjHHA.3940@TK2MSFTNGP02.phx.gbl...
>> Hello Hari,
>>
>> Thanks for your answer. I need to do it when installing SQL 2005. The
>> process will be automated and it will be difficult to do after the
>> installation.
>>
>> Is there a way to do it during the installation?
>>
>> Thank you very much for your time!
>>
>> Jack
>>
>> ================================================== ========================
>>
>> "Hari Prasad" <hari_prasad_k@hotmail.com> a écrit dans le message de
>> news: %23Djr$rSjHHA.2120@TK2MSFTNGP03.phx.gbl...
>>
>>> Hello,
>>>
>>> Alter the SQL Server intallation go to SQL Server management studio -
>>> connect to the database server-- right click above the server name and
>>> click properties.
>>> After that go to database setttings tab-- there change the data and log
>>> locations and click OK.
>>>
>>> THanks
>>> Hari
>>>
>>>
>>> "Jacques" <JBouchard@compugen.com> wrote in message
>>> news:%2331WZwOjHHA.1220@TK2MSFTNGP03.phx.gbl...
>>>> Hi there,
>>>>
>>>> I'm installing SQL server 2005 and I need to modify the database
>>>> default location for Data and Logs folders during the setup process but
>>>> I don't find the place to do it.
>>>>
>>>> I've searched on the internet but didn't find the information I need to
>>>> get my job done.
>>>>
>>>> Can you me with that please?
>>>>
>>>> Many thanks
>>>>
>>>> Jack
>>>>
>>>
>>>
>>
>>
>

This is kinda old by now but i figured I would reply just in case someone
found it by searching (As did I).

To do this you can merely run this command from the run prompt with your
media in your cd/dvd drive:

<opticaldrive>:\Servers\setup.exe INSTALLSQLDATADIR=<Path>

Hit enter and durring install it will install the databases to the specified
path. No problem!

"Jacques" wrote:

> Hi there,
>
> I'm installing SQL server 2005 and I need to modify the database default
> location for Data and Logs folders during the setup process but I don't find
> the place to do it.
>
> I've searched on the internet but didn't find the information I need to get
> my job done.
>
> Can you me with that please?
>
> Many thanks
>
> Jack
>
>
>