Solved

How to move Sharepoint Services 3.0 Database to different drive

Posted on 2013-06-05
6
424 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
  • 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
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 …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
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…

679 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