Solved

How to move Sharepoint Services 3.0 Database to different drive

Posted on 2013-06-05
6
425 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add a loading gif while php runs server side 15 96
Exchange OWA website Redirection 7 81
Expanding/Collapsing Tree on SharePoint List 29 66
MS SharePoint Services 2 37
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
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
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

751 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