How to move Microsoft SQL Server data to different disk drive

Recently just re-installed the Microsoft Office SharePoint Server (MOSS) 2007 applications and database on new servers. But the SharePoint data files were in the C: system drive, which does not have enough space.

To move database files to the D: data drive, what I needed to do is

1. Remove Content Database from the SharePoint Administrative Central.
2. Deattch the database from Microsoft SQl server
3. Move data files to the D: drive
4. Re-attach the database
5. Add Content Database to Web Application.

Related posts

• [Updated] How to move task list item into sub-folders on sharepoint (1)
• How to update Oracle column with sequence numbers (3)
• How to resolve “‘Edit Document’ requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater” error (7)
• How to pass InfoPath form fields to SharePoint workflow but hide from Document Library item properties (0)
• How to move task list item into sub folders on SharePoint site (3)