Solved

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

Posted on 2010-09-22
11
456 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:dteshome
[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
  • 3
  • +1
11 Comments
 
LVL 7

Expert Comment

by:EagleUK
ID: 33738543
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!
0
 

Author Comment

by:dteshome
ID: 33739008
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
0
 
LVL 7

Accepted Solution

by:
EagleUK earned 300 total points
ID: 33740449
You should be able to install to the D: drive. Read the documentation first to figure out how to do that. For most applications, it's simply a matter of specifiying the D: drive during setup. For some applications, you might have to change a configuration file before you install.

To administer SharePoint, you will use Central Administration, which is a web application already installed on your SharePoint server. The SQL Server Express Edition is severely limited in what you can do with it, but you should beable to do everything that you need from Central Administration. I recommend that you move this to a separate SQL Server at your first opportunity, particularly if your C: drive is nearly full. SSEE is primarily for evaluation or development scenarios, not production servers. You will definitely need the full version if you plan to do any significant DB development work. You shouldn't be accessing your SharePoint DBs from SQL anyway, as a general rule. It's very easy to break SharePoint that way. Are you making regular backups?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:dteshome
ID: 33740552
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
0
 
LVL 7

Expert Comment

by:EagleUK
ID: 33748093
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.
0
 
LVL 11

Assisted Solution

by:FastFngrz
FastFngrz earned 200 total points
ID: 33749753
First off, get a copy of www.packetex.com/cooltools/dirgraph.exe and find 'junk' on the C: drive. at 99% full, you are not going to install any SQL tools to move databases around easily.  Common tricks to try:
- Move swap file to D:
- del C:\*.dmp /s (you might wanna dir C:\*.dmp first)
- clear out temp files of \windows\temp and %temp% /s
- uninstall programs that are no longer used.
- Delete user profiles of users that aren't there anymore (computer-properties-advanced-user profiles)

Blue is compressed, and is very bad for the performance of SQL/Exchange databases.

Once you have a little space, you can use the either SSMS (you'll have to connect with named pipes- See http://support.microsoft.com/kb/265808) or if you are a good DBA, use OSQL or SQLCMD and a sp_detach, move the files, followed by an sp_attach.  

If you follow the MS article, you can also use a remote SSMS tool connect via IP port 1433 and  detach, then move the files (regular old copy command) and attach via the SSMS GUI.

0
 
LVL 5

Expert Comment

by:dmoghe
ID: 33752476
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.
0
 
LVL 11

Expert Comment

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

Author Closing Comment

by:dteshome
ID: 33755774
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
0
 
LVL 5

Expert Comment

by:dmoghe
ID: 33763790
Hey D,

Thanks for correcting me. Good documentation... :)
0
 
LVL 11

Expert Comment

by:FastFngrz
ID: 33764380
Live and learn, eh?! Shalom!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

735 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