Solved

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

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql Permission 6 42
setup share and NTFS permissions. 12 60
Problem with SqlConnection 5 109
Connecting two servers 30 46
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

707 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

13 Experts available now in Live!

Get 1:1 Help Now