Tuesday, March 20, 2012

Path of SystemDB during SQL Server 2005 Installation

Hello,
During SQL Server 2005 Installation I would like to change the path for .mdf
on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
Can anybody guide me how we can do it?
Thanks in advance,
MBsee the following link
http://support.microsoft.com/kb/224071
VT
"MB" <mital.bhadaniya@.itcinfotech.com> wrote in message
news:OAsMHNcJHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> During SQL Server 2005 Installation I would like to change the path for
> .mdf
> on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
> Can anybody guide me how we can do it?
> Thanks in advance,
> MB
>|||Hello,
During the SETUP process; in the Feature selection, option select database
services; click browse and change the drive and directory
and continue the installation.
Thanks
Hari
"MB" <mital.bhadaniya@.itcinfotech.com> wrote in message
news:OAsMHNcJHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> During SQL Server 2005 Installation I would like to change the path for
> .mdf
> on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
> Can anybody guide me how we can do it?
> Thanks in advance,
> MB
>|||Thank you Vinu & Hari,
Actually I am looking for the specific location only. When we change
location while doing installation it's installing other folders also and the
.mdf & .ldf location won't be exact as we desired an on the same drive.
Hence, the only solution is attached and detached db.
But I am looking for any optins how we can do it on SQL Server 2000. i.e.
specifying exact location for .mdf & .ldf
Best Regards,
Mital Bhadaniya
"MB" <mital.bhadaniya@.itcinfotech.com> wrote in message
news:OAsMHNcJHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> During SQL Server 2005 Installation I would like to change the path for
> .mdf
> on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
> Can anybody guide me how we can do it?
> Thanks in advance,
> MB
>

No comments:

Post a Comment