?
Solved

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

Posted on 2008-10-27
4
Medium Priority
?
3,029 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
3 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

601 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