Solved

Moving Sharepoint Services Database

Posted on 2014-07-27
2
349 Views
Last Modified: 2014-08-07
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
Comment
Question by:datzent83
2 Comments
 
LVL 29

Assisted Solution

by:QPR
QPR earned 250 total points
ID: 40223554
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
 
LVL 8

Accepted Solution

by:
Jayaraja Jayaraman earned 250 total points
ID: 40224146
detach the db, move mdf and ldf to different location, attach the db again, eazy beezee...
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question