Change logfile location durring setup SQL 2000

[Sjaak van Esdonk]

Is there a possibility to change the default instalation directory for
the logfiles for sql server 2000? I would like the default database
files to be placed on teh d: drive and the logfiles on the e: drive?

Sjaak van Esdonk

[Simon Hayes]

Re: Change logfile location durring setup SQL 2000

sjaakvanesdonk@ hotmail.com (Sjaak van Esdonk) wrote in message news:<7479e65c. 0311130551.56e8 4f0c@posting.go ogle.com>...[color=blue]
> Is there a possibility to change the default instalation directory for
> the logfiles for sql server 2000? I would like the default database
> files to be placed on teh d: drive and the logfiles on the e: drive?
>
> Sjaak van Esdonk[/color]

Setup doesn't have a separate path for the log files, however in
Enterprise Manager you can go into the Server Properties, and on the
Database Settings tab you can select a default location for new
database files. These values are saved in registry keys, so if you
need to do it programmaticall y, you can edit the registry directly:

HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\MSSQLServe r\DefaultData
HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\MSSQLServe r\DefaultLog

Simon

[Sjaak van Esdonk]

Re: Change logfile location durring setup SQL 2000

Thanks Simon, that seems to work !!