Data and Log files

Installing SQL 2005, how can I specify what volume to put my Data and
Log files on? I do not see the option.
thanks
RickRick
For system databases?
"Rick" <drummer10980@.gmail.com> wrote in message
news:1193907987.542408.315030@.v3g2000hsg.googlegroups.com...
> Installing SQL 2005, how can I specify what volume to put my Data and
> Log files on? I do not see the option.
> thanks
> Rick
>|||On Nov 1, 5:44 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Rick
> For system databases?
> "Rick" <drummer10...@.gmail.com> wrote in message
> news:1193907987.542408.315030@.v3g2000hsg.googlegroups.com...
>
> > Installing SQL 2005, how can I specify what volume to put my Data and
> > Log files on? I do not see the option.
> > thanks
> > Rick- Hide quoted text -
> - Show quoted text -
for Databases I add, in 2000 I could use options to change drive
letters.
Rick|||Rick
RESTORE DATABASE has WITH MOVE option to place files on different location.
See also sp_attach stored procedure
"Rick" <drummer10980@.gmail.com> wrote in message
news:1193919657.400277.87190@.y42g2000hsy.googlegroups.com...
> On Nov 1, 5:44 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
>> Rick
>> For system databases?
>> "Rick" <drummer10...@.gmail.com> wrote in message
>> news:1193907987.542408.315030@.v3g2000hsg.googlegroups.com...
>>
>> > Installing SQL 2005, how can I specify what volume to put my Data and
>> > Log files on? I do not see the option.
>> > thanks
>> > Rick- Hide quoted text -
>> - Show quoted text -
> for Databases I add, in 2000 I could use options to change drive
> letters.
> Rick
>|||You mean default directory for database files? You can do that in SSMS. Object Explorer, right-click
your instance, properties and the "Database settings" page.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Rick" <drummer10980@.gmail.com> wrote in message
news:1193919657.400277.87190@.y42g2000hsy.googlegroups.com...
> On Nov 1, 5:44 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
>> Rick
>> For system databases?
>> "Rick" <drummer10...@.gmail.com> wrote in message
>> news:1193907987.542408.315030@.v3g2000hsg.googlegroups.com...
>>
>> > Installing SQL 2005, how can I specify what volume to put my Data and
>> > Log files on? I do not see the option.
>> > thanks
>> > Rick- Hide quoted text -
>> - Show quoted text -
> for Databases I add, in 2000 I could use options to change drive
> letters.
> Rick
>|||On Nov 1, 8:39 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> You mean default directory for database files? You can do that in SSMS. Object Explorer, right-click
> your instance, properties and the "Database settings" page.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Rick" <drummer10...@.gmail.com> wrote in message
> news:1193919657.400277.87190@.y42g2000hsy.googlegroups.com...
>
> > On Nov 1, 5:44 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> >> Rick
> >> For system databases?
> >> "Rick" <drummer10...@.gmail.com> wrote in message
> >>news:1193907987.542408.315030@.v3g2000hsg.googlegroups.com...
> >> > Installing SQL 2005, how can I specify what volume to put my Data and
> >> > Log files on? I do not see the option.
> >> > thanks
> >> > Rick- Hide quoted text -
> >> - Show quoted text -
> > for Databases I add, in 2000 I could use options to change drive
> > letters.
> > Rick- Hide quoted text -
> - Show quoted text -
that is what i needed, thanks
Rick