How to move Sharepoint Services 3.0 Database to different drive

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
tobe1424Asked:
Who is Participating?
 
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
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
 
tobe1424Author Commented:
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
 
tobe1424Author Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Justin SmithSr. System EngineerCommented:
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
 
tobe1424Author Commented:
here is the thing...i cant really access Sharepoint because the server is critically low on disk space.. <100Mb
0
 
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.