Showing posts with label systemdb. Show all posts
Showing posts with label systemdb. Show all posts

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
>