Solved

Moving Sharepoint Services Database

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharepoint workflow on list 6 36
how to compare 2 PST files? 3 90
Windows 10 VPN? 6 73
Remote Desktop GATEWAY server 2008 to 2012 cutover 5 47
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…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now