flugaurj
asked on
Sharepoint Disk Space Question (SPS 3.0)
We are currently running Server 2008 with only SPS 3.0 on top of it and it just keeps eating up disk space. Currently we have a 90 gb HD with only 10 gb free. When I do an export of the site using STSADM the whole site only takes up 1.3gb. I am just wondering what is eating up all this disk space if I am only running Server 2008 with Sharepoint on top of it. I have had to add over 30gb of disk space to the server in the past few months. I have cleared out some log files but that still doesn't account for all the disk space taken up. Any thoughts on why this is happening?
*12 Hive = C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\
To truncate log file you can visit the below link
http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/
ASKER
The log files in that folder are only 58mb...... Any other thoughts?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use a program like WinDirStat (http://windirstat.info/) to analyse your disk to see what exactly is taking up all the space. If it's SharePoint related it's most likely the SQL Server database log files (*.ldf), and HetAlps' link above will show you how to shrink/truncate them.
ASKER
OK I found the log file that is taking up 50gb so how do I shrink it if I have the embedded DB? I am not using SQL 2005
what version of sql are u using
ASKER
It says 2005
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are using the embedded database, then it's SQL Server 2005 Embedded Edition. To manage it you will need to download "SQL Server Management Studio Express" and use the following steps to connect to it: http://blogs.msdn.com/dhirajm/archive/2009/01/26/how-to-connect-sql-embedded-edition-to-sql-management-studio.aspx. Then you should be able to use the steps to shrink the log file.
you may have to dowload an install microsoft visual studio 2005. there a re a few things you will haveto load with it, as per the link below. This is the tool you use to see the dbs and do the shrink and other things
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
steve I must be 5 seconds behind you....
:) and I must be 5 seconds behind Mike
ASKER
That did it! Thanks all!
And
clean your SQL database log files.
Let me know if you need more details.