asked on

Sharepoint 3.0 - cannot file database! need to move mdf/ldf from C drive to another

Hi, Everyone:

I am in this new place where there is no documentation ...

Am asked to look into a Sharepoint serevr, namely, move DB files mdf/ldf from C drive to another.

When I listed the directories, I see all mdf/ldf colored blue (... I guess it is encrypted??) at any rate, I need to move all DB files to D drive.

1st. How do I get to see the DB server being used? I see SQL Server Service Manager is running (little icon with green arrow in the taskbar) and shows
SHAREPOINT\MICROSOFT##SSEE as server, and services, SQL Server
but I can not register the server using SSMS ... I am lost.

Pls help.
Dan

EagleUK

I believe that the blue color represents compressed files rather than encrypted files.

The SQL server that you are using is probably the Express Edition, which is on the same server as SharePoint. The databases are installedon the C: drive by default.

This article shows how to move the databases.
http://blogs.dirteam.com/blogs/mjohnson/archive/2008/02/08/moving-wss-3-0-databases.aspx

Good luck!

dteshome

ASKER

Hi, EagleUK:

I cannot download or install anything on the server becasue the C drive is almost full. Will I be able to choose D or E drive to download the client tools?

Is there a way of "administering " the Express Ed DB serevr on the WSS serevr from another server.

Thanks,
D

ASKER CERTIFIED SOLUTION

EagleUK

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dteshome

ASKER

I have not seen this server until today when they asked me to make room on the C drive ... the drive is 99% full. They backup the data on the server using an enterprise backup system. That is all I know. I will try and install on the D drive.

Do I do the backup using the central admin or continue to have them backup using the Enterprise backup?

Thank you fro your help.
D

EagleUK

You can do both, and many administrators do. I can't recommend a method as I know very little about your environment. Your best bet is to study the documents at the link that I provided and learn more about the product. You can't really expect to manage this server for long based on what you read in a forum, no matter how well meaning the person giving you advice is.

If your drive is that full, you will probably have problems very shortly. I would try to identify any applications that could be moved to a different server to free up room while you are planning what to do with SharePoint.

Hope this helps.

SOLUTION

Daryl Sirota

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dmoghe

Hi,

If you are using SHAREPOINT\MICROSOFT##SSEE, the you do not have any choice to move to other drive as Share point will try to locate the database in the SYSMSI folder in the C: drive. If you have a full blown SQL then you can perform the movement to other drive.

Even if you move to other drive, sharepoint will not be able to connect with the content database.

hope that helps.

Daryl Sirota

dmoghe, I respectfully disagree. See http://www.howtonetworking.com/msapps/wssdata11.htm for the the detailed method to move.

dteshome

ASKER

Thank you all for your valuable comments and solutions. We decided to bring in a consultant for a brief assistance - too much at stake!

Thanks,
D

dmoghe

Hey D,

Thanks for correcting me. Good documentation... :)

Daryl Sirota

Live and learn, eh?! Shalom!