Hi Gang,

Sorry for the stupid question, but I a long-time MySQL user who is new to
SQL Server. I just installed the SQL Server 2005 Standard Edition Trial on
a Windows 2003 R2 System. The install Wizard did not appear to give me an
option of where I wanted the databases to be stored (maybe I missed it) and
placed them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. I
want to put the Data files themselves on the D: drive (which is sized for
data) and leave the program files of SQL Server as is. This is a simple
config change in MySQL, but I went through the tutorial before installing
and I can't see a simple way of doing this in SQL Server. Thank you very
much for your !

Best,

David

what i do is detach the database, then physically move the files to the
proper folder you want, then go to attach a database, and navigate to
the new folder you are using, and you will see your database in there,
and select it.
Jay

David L. Jacobson wrote:
> Hi Gang,
>
> Sorry for the stupid question, but I a long-time MySQL user who is new to
> SQL Server. I just installed the SQL Server 2005 Standard Edition Trial on
> a Windows 2003 R2 System. The install Wizard did not appear to give me an
> option of where I wanted the databases to be stored (maybe I missed it) and
> placed them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. I
> want to put the Data files themselves on the D: drive (which is sized for
> data) and leave the program files of SQL Server as is. This is a simple
> config change in MySQL, but I went through the tutorial before installing
> and I can't see a simple way of doing this in SQL Server. Thank you very
> much for your !
>
> Best,
>
> David
>
>

And in addition to Jay's response, using SSMS, go to Server Properties,
Database Settings, and change the default location for new databases.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Jay B" <jayB@audiman.net> wrote in message
news:njuZg.16$Kh.9@newsfe09.lga...
> what i do is detach the database, then physically move the files to the
> proper folder you want, then go to attach a database, and navigate to the
> new folder you are using, and you will see your database in there, and
> select it.
> Jay
>
> David L. Jacobson wrote:
>> Hi Gang,
>>
>> Sorry for the stupid question, but I a long-time MySQL user who is new to
>> SQL Server. I just installed the SQL Server 2005 Standard Edition Trial
>> on
>> a Windows 2003 R2 System. The install Wizard did not appear to give me
>> an
>> option of where I wanted the databases to be stored (maybe I missed it)
>> and
>> placed them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
>> I
>> want to put the Data files themselves on the D: drive (which is sized for
>> data) and leave the program files of SQL Server as is. This is a simple
>> config change in MySQL, but I went through the tutorial before installing
>> and I can't see a simple way of doing this in SQL Server. Thank you very
>> much for your !
>>
>> Best,
>>
>> David
>>

And in addition to Jay's response, using SSMS, go to Server Properties,
Database Settings, and change the default location for new databases.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Jay B" <jayB@audiman.net> wrote in message
news:njuZg.16$Kh.9@newsfe09.lga...
> what i do is detach the database, then physically move the files to the
> proper folder you want, then go to attach a database, and navigate to the
> new folder you are using, and you will see your database in there, and
> select it.
> Jay
>
> David L. Jacobson wrote:
>> Hi Gang,
>>
>> Sorry for the stupid question, but I a long-time MySQL user who is new to
>> SQL Server. I just installed the SQL Server 2005 Standard Edition Trial
>> on
>> a Windows 2003 R2 System. The install Wizard did not appear to give me
>> an
>> option of where I wanted the databases to be stored (maybe I missed it)
>> and
>> placed them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
>> I
>> want to put the Data files themselves on the D: drive (which is sized for
>> data) and leave the program files of SQL Server as is. This is a simple
>> config change in MySQL, but I went through the tutorial before installing
>> and I can't see a simple way of doing this in SQL Server. Thank you very
>> much for your !
>>
>> Best,
>>
>> David
>>

For System databases Take a look into

http://www.sqlservercentral.com/colu...oboni/2605.asp


For User database use Detach and Attach commands

Thanks
Hari

"David L. Jacobson" <tornadogroup@hotmail.com> wrote in message
news:OciMKct8GHA.2120@TK2MSFTNGP03.phx.gbl...
> Hi Gang,
>
> Sorry for the stupid question, but I a long-time MySQL user who is new to
> SQL Server. I just installed the SQL Server 2005 Standard Edition Trial
> on
> a Windows 2003 R2 System. The install Wizard did not appear to give me an
> option of where I wanted the databases to be stored (maybe I missed it)
> and
> placed them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
> I
> want to put the Data files themselves on the D: drive (which is sized for
> data) and leave the program files of SQL Server as is. This is a simple
> config change in MySQL, but I went through the tutorial before installing
> and I can't see a simple way of doing this in SQL Server. Thank you very
> much for your !
>
> Best,
>
> David
>
>

Thanks, Gang. That was a snap. I really appreciate the assistance.

Best,

David

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%238ukIFy8GHA.2092@TK2MSFTNGP03.phx.gbl...
> For System databases Take a look into
>
> http://www.sqlservercentral.com/colu...oboni/2605.asp
>
>
> For User database use Detach and Attach commands
>
> Thanks
> Hari
>
> "David L. Jacobson" <tornadogroup@hotmail.com> wrote in message
> news:OciMKct8GHA.2120@TK2MSFTNGP03.phx.gbl...
> > Hi Gang,
> >
> > Sorry for the stupid question, but I a long-time MySQL user who is new
to
> > SQL Server. I just installed the SQL Server 2005 Standard Edition Trial
> > on
> > a Windows 2003 R2 System. The install Wizard did not appear to give me
an
> > option of where I wanted the databases to be stored (maybe I missed it)
> > and
> > placed them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
> > I
> > want to put the Data files themselves on the D: drive (which is sized
for
> > data) and leave the program files of SQL Server as is. This is a simple
> > config change in MySQL, but I went through the tutorial before
installing
> > and I can't see a simple way of doing this in SQL Server. Thank you
very
> > much for your !
> >
> > Best,
> >
> > David
> >
> >
>
>