moving SQL location

Hello,

In process of installing TFS, I unintentionally installed SQL server on C drive as I could'n see any option of selecting the drives.

Is there any way in which I can move the database folder to another drive without reformatting and going through the same procedure.

TIA

Krisna,

What version of SQL server are you running?

Yes, you can move the DB folders, although SQL server itself will want to stay on the C drive.

Note the names of your user databases, (in the properties of the databases themselves) and then drop them. Then copy/move them to the new location and re-attach.

The system databases (master. model, tempdb and msdb) are a different kettle of fish though. Instructions for moving all databases is here:

http://support.microsoft.com/kb/224071/en-us

Moving Primary Transaction log

After installing SQL server 2000 STD, SP3 how can I move primary transaction
log to another drive?
ThanksBACKUP and RESTORE WITH MOVE
or the quicker method:
sp_detach_db
copy the file
sp_attach_db
You will be able to find documentation on each of these methods within Books
Online (within the SQL Server program group).
--
Keith
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:7C5C9BAF-E835-413B-8F57-4581170BF33A@.microsoft.com...
> After installing SQL server 2000 STD, SP3 how can I move primary
transaction
> log to another drive?
> Thanks
>

Moving Primary Transaction log

After installing SQL server 2000 STD, SP3 how can I move primary transaction
log to another drive?
Thanks
BACKUP and RESTORE WITH MOVE
or the quicker method:
sp_detach_db
copy the file
sp_attach_db
You will be able to find documentation on each of these methods within Books
Online (within the SQL Server program group).
Keith
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:7C5C9BAF-E835-413B-8F57-4581170BF33A@.microsoft.com...
> After installing SQL server 2000 STD, SP3 how can I move primary
transaction
> log to another drive?
> Thanks
>

Moving Primary Transaction log

After installing SQL server 2000 STD, SP3 how can I move primary transaction
log to another drive?
ThanksBACKUP and RESTORE WITH MOVE
or the quicker method:
sp_detach_db
copy the file
sp_attach_db
You will be able to find documentation on each of these methods within Books
Online (within the SQL Server program group).
Keith
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:7C5C9BAF-E835-413B-8F57-4581170BF33A@.microsoft.com...
> After installing SQL server 2000 STD, SP3 how can I move primary
transaction
> log to another drive?
> Thanks
>