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)
• Resolve Access Denied Error while creating new article page in SharePoint MOSS 2007 (2)
• Post emails onto SharePoint list (3)
• Issues with creating Database Connections to Oracle in SharePoint Designer 2007 (Resolved) (4)
• How to update Oracle column with sequence numbers (3)