Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to move Sharepoint Services 3.0 Database to different drive

Posted on 2013-06-05
6
Medium Priority
?
428 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 2000 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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
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 2000 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 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