Solved

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

Posted on 2008-10-27
4
2,951 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 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 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 250 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

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

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
Learn about cloud computing and its benefits for small business owners.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

867 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

20 Experts available now in Live!

Get 1:1 Help Now