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

x
?
Solved

How to move Sharepoint_Config DB from c:\windows\sysmsi to another drive?

Posted on 2008-10-27
4
Medium Priority
?
3,008 Views
Last Modified: 2012-05-05
How do I move Sharepoint_Config DB from c:\windows\sysmsi\sse\mssql2005\mssql\data to another drive? Just found out our drive is low on space and found that DB on C drive that is 5GB.

Thank you
0
Comment
Question by:piotrmikula108
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 750 total points
ID: 22817011
3 steps:
? stop sharepoint services
? move the database
  http://support.microsoft.com/kb/224071 
? start sharepoint services

0
 
LVL 1

Author Comment

by:piotrmikula108
ID: 22817132
actually it's the SharePoint_Config_66db1b50-91ab-466e-9fe8-c2c46c024510_log.LDF  log file, can I just delete it or shrink it?
0
 
LVL 2

Assisted Solution

by:mdalfreddo
mdalfreddo earned 750 total points
ID: 22817179
- stop sharepoint services and frontend IIS web servers
- full shrink the database
- detach
- move the database files
- re-attach the database files
- restart services and frontend
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

926 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