Installing SQL 2005

Hi,
i haved installed SQL 2005 and i didn't while installing any option that i
can tell to setup install database on another drive.
Now how can i change die database and programm on diferent drives?
Thanks
PITYou can detach and reattach the databases. Before you reattach them, copy
them to the new drive. To attach, connect to your SQL Server in SQL Server
Management Studio and drill down to the databases folder, right click on the
databases folder, and select Attach.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"PIT" <PIT@.newsgroup.nospam> wrote in message
news:DC36E4F5-7E23-47D9-9E5E-552EB0395AB4@.microsoft.com...
> Hi,
> i haved installed SQL 2005 and i didn't while installing any option that i
> can tell to setup install database on another drive.
> Now how can i change die database and programm on diferent drives?
> Thanks
> PIT
>|||hi,
for other database i see an option to dettach. but for systemdatabase which
is on c:\ i can't see anything to dettach it.
how can i dettach systemdatabase?
Regards, PIT
"Hilary Cotter" wrote:
> You can detach and reattach the databases. Before you reattach them, copy
> them to the new drive. To attach, connect to your SQL Server in SQL Server
> Management Studio and drill down to the databases folder, right click on the
> databases folder, and select Attach.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "PIT" <PIT@.newsgroup.nospam> wrote in message
> news:DC36E4F5-7E23-47D9-9E5E-552EB0395AB4@.microsoft.com...
> > Hi,
> >
> > i haved installed SQL 2005 and i didn't while installing any option that i
> > can tell to setup install database on another drive.
> >
> > Now how can i change die database and programm on diferent drives?
> >
> > Thanks
> >
> > PIT
> >
>
>|||You can't detach it. The SQL Server requires it to be there in order to
function. If you could detach it, it would imediately take the entire SQL
Server offline which would prevent you from attaching it again. BOL has a
very detailed document for moving system databases.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"PIT" <PIT@.newsgroup.nospam> wrote in message
news:067B4CD1-CD78-412A-B815-E52FFDCD5AC4@.microsoft.com...
> hi,
> for other database i see an option to dettach. but for systemdatabase
> which
> is on c:\ i can't see anything to dettach it.
> how can i dettach systemdatabase?
> Regards, PIT
>
> "Hilary Cotter" wrote:
>> You can detach and reattach the databases. Before you reattach them, copy
>> them to the new drive. To attach, connect to your SQL Server in SQL
>> Server
>> Management Studio and drill down to the databases folder, right click on
>> the
>> databases folder, and select Attach.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "PIT" <PIT@.newsgroup.nospam> wrote in message
>> news:DC36E4F5-7E23-47D9-9E5E-552EB0395AB4@.microsoft.com...
>> > Hi,
>> >
>> > i haved installed SQL 2005 and i didn't while installing any option
>> > that i
>> > can tell to setup install database on another drive.
>> >
>> > Now how can i change die database and programm on diferent drives?
>> >
>> > Thanks
>> >
>> > PIT
>> >
>>