sql server 2005 data location

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ginger8990 - 26 Mar 2008 16:16 GMT

I am not so familiar with sql 2005. I cannot point my data to other drives
such as D:\ or E:\.

When I installed sql 2000, it gives me the option to select data folder to a
different location and program files are on C:\

Can any of you please give some help?

Reply to this Message

lonnye - 26 Mar 2008 16:42 GMT

You should be able to change the location of the data during installation.
If you can't however, you could always move the system databases (see
http://support.microsoft.com/kb/224071).
You can also set the default data/log path once you've installed by going to
the Server properties - Database settings.
Hope this helps.

Signature

~lb

> I am not so familiar with sql 2005. I cannot point my data to other drives
> such as D:\ or E:\.
[quoted text clipped - 3 lines]
>
> Can any of you please give some help?

Reply to this Message

ginger8990 - 26 Mar 2008 22:13 GMT

It didn't give me the option when I install sql 2005 but I can change the
data location when I created a new databse.

> You should be able to change the location of the data during installation.
> If you can't however, you could always move the system databases (see
[quoted text clipped - 10 lines]
> >
> > Can any of you please give some help?

Reply to this Message

lonnye - 26 Mar 2008 22:47 GMT

The option is kind of hidden during install.
If you expand the database area there is another expandable section named
data and then you can browse for where you would like to install the data.
I recently learned, however, that the install installs all the data per SQL
instance into whichever default location with numbered folders in the order
in which you install the services.
Example...
Monday - you install the database engine - the data files go into
C:\...\MSSQL.1
Tuesday - you install reporting services - the data files go into
C:\...\MSSQL.2
Wednesday - you install analysis services - the data files go into
C:\...\MSSQL.3
I hope this additional info helps.

Signature

~lb

> It didn't give me the option when I install sql 2005 but I can change the
> data location when I created a new databse.
[quoted text clipped - 13 lines]
> > >
> > > Can any of you please give some help?

Reply to this Message