is it possible to move my sql 2000 database (in C disk) to another disk (Disk) ?

hello,all

I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure) from C Disk to D Disk(its space is very large) .

is it possible to do it ?

if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal report connectstring ) ?

thanks in advanced!

You can "detach" the detabase, physically copy/move the files (*.mdf and *.ldf files) to the new location, then "attach" the DB and select the files from the new location. You dont need to change anything on the application level.