Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

Moving Sharepoint Services Database

We recently added additional space to the server on a separate partition. We needed to free up space on the OS (C) drive. Through the SBS Console we chose to move Sharepoint Services Database to the new partition. At the end of the wizard we got the following error:

Unable to delete the old windows sharepoint services database file. You will need to delete the database file manually from: {0}

I do see the log.ldf file on the new partition which is the exact same size as the original location.

My questions are, do I remove the log.ldf from the original location. Is the log.ldf on the partition a healthy file or is it corrupt?
0
datzent83
Asked:
datzent83
2 Solutions
 
QPRCommented:
You normally cannot delete an mdf/ldf (after copying the files to new locations) while the sql service is still running.
Right click on the database name choose properties - files. Ensure the files are pointing to the new location.
Make sure your Sharepoint service is operating correctly.
Stop the sql service and then delete the original mdf and ldf files
0
 
Jayaraja JayaramanCommented:
detach the db, move mdf and ldf to different location, attach the db again, eazy beezee...
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now