Solved

Moving Sharepoint Services Database

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 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