db file folder

hi. i'm new to sql server administration.
i've a instance whose default store folder is C:\SQLDB. i would like to
move the 3 databases that run on it to another harddrive. what's the
way to do this?
1) create backups of the 3 databases.
2) uninstall sqlserver
3) instal sqlserver with the store folder pointing to the new drive
4) restore the 3 databases?
seems like there should be a shorter way
thanx riyazHi
Actually , you have two options ( mabe more , i'd prefer those two)
1) BACKUP DATABASE and RESTORE ... WITH MOVE options (for more details
please refer to BOL)
2) sp_detach_db , then move the .MDF,LDF files to the new location and them
issue sp_attach_db stored procedure
<rmanchu@.gmail.com> wrote in message
news:1146990766.264052.197800@.y43g2000cwc.googlegroups.com...
> hi. i'm new to sql server administration.
> i've a instance whose default store folder is C:\SQLDB. i would like to
> move the 3 databases that run on it to another harddrive. what's the
> way to do this?
> 1) create backups of the 3 databases.
> 2) uninstall sqlserver
> 3) instal sqlserver with the store folder pointing to the new drive
> 4) restore the 3 databases?
> seems like there should be a shorter way
> thanx riyaz
>|||I'd recommend that you use the detach/attach method. You should make sure
that you backup the machine before doing this, just to be on the safe side.
SSMS and Enterprise manager allow you to control the detach and attach
process really well, so if you're doing this as a one of just use the front
end tools. If you need to do lots of severs which are configured the same,
then script the commands from the tools as this will save time later.
Regards
Colin Dawson
www.cjdawson.com
<rmanchu@.gmail.com> wrote in message
news:1146990766.264052.197800@.y43g2000cwc.googlegroups.com...
> hi. i'm new to sql server administration.
> i've a instance whose default store folder is C:\SQLDB. i would like to
> move the 3 databases that run on it to another harddrive. what's the
> way to do this?
> 1) create backups of the 3 databases.
> 2) uninstall sqlserver
> 3) instal sqlserver with the store folder pointing to the new drive
> 4) restore the 3 databases?
> seems like there should be a shorter way
> thanx riyaz
>