SharePoint 3 log file too large
Hello,
We have a client with SharePoint 3 on SBS 2003. It was installed along side the standard SharePoint 2 as per Microsoft's guidelines. Currently, the SharePoint_Config...ldf log file is 7.8gb. I can't connect to it using the SQL Management Studio Express to run the shrink commands I have found online. Basically, I would rather have the space it's taking up then have SharePoint 3. In fact, we are putting SharePoint 3 on a separate server, so I don't need it at all on this SBS 2003 server.
Can I disable SharePoint and delete the log file? Again, I don't want it on this server anyway, and I need to get the space back that the log file is using.
Thanks!
Jeff
We have a client with SharePoint 3 on SBS 2003. It was installed along side the standard SharePoint 2 as per Microsoft's guidelines. Currently, the SharePoint_Config...ldf log file is 7.8gb. I can't connect to it using the SQL Management Studio Express to run the shrink commands I have found online. Basically, I would rather have the space it's taking up then have SharePoint 3. In fact, we are putting SharePoint 3 on a separate server, so I don't need it at all on this SBS 2003 server.
Can I disable SharePoint and delete the log file? Again, I don't want it on this server anyway, and I need to get the space back that the log file is using.
Thanks!
Jeff
If you are not going to use sharepoint anymore on that server I would uninstall it rather than just delete the file, after uninstall you can safely delete the db files if they are still there. Ofcourse if there is data in the sharepoint site, migrate it first before you uninstall or delete anything ...
ASKER
Broeckske: We are not using SharePoint 3 on this server. I want to make sure I can uninstall it from SBS 2003 since the install process was very specific.
Thanks!
Thanks!
If you just stop the databases and delete the files that will work too but you may receive some errors in your event logs from services like the sbs monitor ...
there is a MS KB on how to uninstall the SHarepoint services on a SBS 2003
http://support.microsoft.com/kb/829114
there is a MS KB on how to uninstall the SHarepoint services on a SBS 2003
http://support.microsoft.com/kb/829114
ASKER
Broeckske: I saw that Microsoft article, but it only talks about Sharepoint 2. I need to uninstall the Sharepoint 3 installation. Just want to make sure I do it correctly.
Jeff
Jeff
Check this MS article on removing Sharepoint 3
http://blogs.technet.com/b/edwalt/archive/2006/11/29/removing-wss-3-0-companyweb-upgrade-restoring-wss-2-0-on-sbs-2003.aspx
It also talks about reinstalling sharepoint v2, that I would just skip
http://blogs.technet.com/b/edwalt/archive/2006/11/29/removing-wss-3-0-companyweb-upgrade-restoring-wss-2-0-on-sbs-2003.aspx
It also talks about reinstalling sharepoint v2, that I would just skip
ASKER
Broeckske: That article talks about removing WSS 3 if it's been used to replace Companyweb on SBS2003 rather than installed in a side-by-side manner as Microsoft recommends. We installed as a side-by-side. Do you think it would be as simple as just removing WSS 3 from Add/Remove programs? I'd rather not mess with WSS 2 at all.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
JAStillwell, since you are not using it you can safely remove the Sharepoint 3 like described in the article and don't do the Sharpoint 2 part
If your running windows sharepoint services 3.0 with windows internal database, there is a way to can connect to the windows internal database from SQL Management Studio Express in order to run the shrink commands.
When you open SQL Management Studio Express you need to type the following into the server name:
\\.\pipe\mssql$microsoft##
then connect using windows authentication.
When you open SQL Management Studio Express you need to type the following into the server name:
\\.\pipe\mssql$microsoft##
then connect using windows authentication.