Solved

How to move Sharepoint Services 3.0 Database to different drive

Posted on 2013-06-05
6
426 Views
Last Modified: 2013-06-28
Hello,

I currently have the free version of Sharepoint installed. I installed this a while back ago using default so unfortunately the embedded windows database is on drive c:

How can i go about moving it to drive d on the same computer..same drive just different partition?

Thx
T
0
Comment
Question by:tobe1424
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 39224162
SharePoint doesn't care about the drive - so this is done almost entirely outside of SharePoint.

First, you need to have SQL Management Studio (or Express) installed on your machine so you can access your SQL instance.

1. Shut down all SharePoint services via services.msc.  Also run iisreset /stop from command line (assuming you only have SharePoint sites running in IIS)

2. In SQL Manager, right click each SharePoint database and choose to Detach.

3. Move your database files (mdf and ldf)

4. In SQL Manager, right click your server name and choose to attach database.  Attach all moved db's.

5. Run iisreset /start from command line.  Start all SharePoint services.
0
 

Author Comment

by:tobe1424
ID: 39226240
ok thanks so much for the clear instructions.

Since i installed this a while ago i don't recall installing sql mgmt studio or express..i do see sql 2008 for some reason..not installed..but the options you see in the screen shot.

can i install management studio by using the installation center?

program files
0
 

Author Comment

by:tobe1424
ID: 39226269
i just thought that for some reason this would be running in 2005 since this is the directory where the db files reside:

C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
LVL 38

Expert Comment

by:Justin Smith
ID: 39226323
I believe that is the directory to the internal db server.

When you look in Central Admin - Servers in Farm.....what is your db server listed as?

Most likely you'll need to download and install SQL MGMT Studio Express.  Or, you can install Management Tools from SQL Media.
0
 

Author Comment

by:tobe1424
ID: 39229818
here is the thing...i cant really access Sharepoint because the server is critically low on disk space.. <100Mb
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 39229852
That's fine.  Just download SQL manager and try to connect to the default instance.  More than likely, however, it's going to need this connection string:  http://www.mssqltips.com/sqlservertip/1577/administering-your-windows-internal-database-microsoftssee-instance/
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
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...
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

617 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