Solved

Moving Sharepoint Services Database

Posted on 2014-07-27
2
350 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
My Sharepoint challenge 4 55
Problems with VOIP phones and Comcast Business internet connection 27 122
SBS2008 Backup 2 36
SBS 2011 - Exchange - Can't received internal 1 34
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…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

685 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