How to change the location of the Windows SharePoint Services database file

How To Move Sharepoint Server 2007 Database To Another Drive?

  procedure of moving sharepoint sql content data os drive to other drive

step1: identify source data location

sp_helpdb WSS_Content_5656

   

note: source data located into  Operating system drive(C:/) 

step2: take back up

backup database [WSS_Content_5656] to disk ='F:\WSS_Content_5656_11082010.bak' with stats=5
note: backup will stored into F:\ drive

 step3:
   alter database [WSS_Content_5656] set offline with rollback immediate 

step4:
   exec sp_detach_db 'WSS_Content_5656','true'

note: after detach cut the .mdf and .ldf file in os drive  and copy into desire drive(d:\)
    and attach to content db

step5:
   exec sp_attach_db @dbname=N'WSS_Content_5656',@filename1=N'D:\WSS_Content_5656.mdf'
,@filename2=N'D:\WSS_Content_5656_log.ldf'

step6: check you are desired location 

sp_helpdb WSS_Content_5656

note:  Move Sharepoint content  data " os drive(c:\)"  into d:\ drive

 More Information:

http://njbblog.blogspot.com/2009/03/sharepoint-30-how-to-move-sql-database.html

http://technet.microsoft.com/en-us/library/dd277864(office.12).aspx

http://blogs.techrepublic.com.com/window-on-windows/?p=454


http://www.sharepointdev.net/sharepoint--setup-upgrade-administration-operation/how-to-move-sharepoint-services-30-sp1-database-to-another-drive-2019.shtml

Microsoft Links:

http://support.microsoft.com/kb/843580