• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

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?
0
flugaurj
Asked:
flugaurj
  • 4
  • 4
  • 3
  • +2
2 Solutions
 
HetAlpsCommented:
You can remove all old log files from 12 Hive\logs folder.

And

clean your SQL database log files.

Let me know if you need more details.


0
 
HetAlpsCommented:

*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/
0
 
flugaurjAuthor Commented:
The log files in that folder are only 58mb...... Any other thoughts?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
mccarthybriCommented:
it is probably your database transactions logs growing.

the translog files are the file ldf, that go with your portal database file mdf.

to shrink them follow the info on this page

http://support.microsoft.com/kb/907511

0
 
StevenMulkerrinsCommented:
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.
0
 
flugaurjAuthor Commented:
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
0
 
mccarthybriCommented:
what version of sql are u using
0
 
flugaurjAuthor Commented:
It says 2005
0
 
rdcproCommented:
Oh, you're using the embedded edition of SQL Server!  That's a little harder to manage.  You can connect to it with Management Studio, but you have to use named pipes and you have to be on the physical machine.  For example, when you launch management studio, in the prompt to connect to a SQL Server, where you would normally use something like:
\\ServerName\InstanceName
Instead use:
\\.\pipe\mssql$microsoft##ssee\sql\query
Then you can trucate the transaction log, per the previous link.
Regards,
Mike Sharp
0
 
StevenMulkerrinsCommented:
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.
0
 
mccarthybriCommented:
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
0
 
mccarthybriCommented:
steve I must be 5 seconds behind you....
0
 
StevenMulkerrinsCommented:
:) and I must be 5 seconds behind Mike
0
 
flugaurjAuthor Commented:
That did it! Thanks all!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 4
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now