Go Back   Technibble Forums > General Computers > Tech-to-Tech Computer Help

  Technibble Sponsor

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2012, 12:24 PM
knc knc is offline
 
Join Date: Feb 2010
Location: Kingston, Ny
Posts: 342
knc can only hope to improve
Default SBS server 2008 bleeding disk space..

I have an SBS 2008 that is bleeding disk space... I was down to 200 mb's so I moved the pagefile.sys to their D: drive... that gave me about 8 gigs free, which immediately started shrinking...

I see the sharepoint database file is 17gb, and can't understand how to manage it. I found a microsoft "fix it" for me tool to shrink the log file but that didn't help much.

I may move the sharepoint database to the d drive through the sbs migration wizard.

I turned of logging on many features but my log folder isnt THAT large..

I am not using the sharepoint services at all (at least that I know) and the server is running AD but all clients 4 or 5 are connecting as if it was a workgroup. Boy the 17 gb of sharepoint data would be sweet to have back..
Reply With Quote
  #2  
Old 02-23-2012, 01:21 PM
MobileTechie's Avatar
MobileTechie MobileTechie is offline
 
Join Date: Oct 2009
Location: UK
Posts: 4,254
MobileTechie has a spectacular aura aboutMobileTechie has a spectacular aura about
Default

So just to be clear - which file is it that is very large?

Last edited by MobileTechie; 02-23-2012 at 01:44 PM.
Reply With Quote
  #3  
Old 02-23-2012, 01:39 PM
seedubya's Avatar
seedubya seedubya is offline
 
Join Date: Jan 2008
Location: Carlow, Ireland
Posts: 3,227
seedubya has a spectacular aura aboutseedubya has a spectacular aura about
Default

Please use a disk space analyser to determine where the space is going, if you don't already know. Once we know that it may be possible to help.
Reply With Quote
  #4  
Old 02-23-2012, 01:46 PM
MobileTechie's Avatar
MobileTechie MobileTechie is offline
 
Join Date: Oct 2009
Location: UK
Posts: 4,254
MobileTechie has a spectacular aura aboutMobileTechie has a spectacular aura about
Default

Sounds like he's already narrowed it down to sharepoint. I'm wondering which file, if it isn't a log file, is 17GB. It's normally the log files.

Have you gone in through SQL Server Management and used the shrink files/database functions?
Reply With Quote
  #5  
Old 02-23-2012, 01:53 PM
YeOldeStonecat's Avatar
YeOldeStonecat YeOldeStonecat is offline
 
Join Date: Nov 2011
Location: Southeast Connecticut
Posts: 7,472
YeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to behold
Default

Look inside of your IIS directory...I bet one of the sites .log files is ballooning.

Where is WSUS installed? SHould always move that off the %system% drive.

Users redirect folders?

Where is the infostore located? (also should be off the %system% drive)...but if it's not backing up properly by an Exchange aware backup utility that can flush the circular logs...she'll balloon up in size too by those log files every 12 or so minutes.
__________________
Resident "Geek on a Harley" doing IT in Southeast Connecticut
http://www.dynamic-alliance.com/
https://www.facebook.com/YeOldeStonecat
Reply With Quote
  #6  
Old 02-23-2012, 08:36 PM
knc knc is offline
 
Join Date: Feb 2010
Location: Kingston, Ny
Posts: 342
knc can only hope to improve
Default

sharepoint****.ldf file is 17 or 18 gb...

I have already looked at wsus and ran the clean up utility, took 5 days for that to finish. I can move sharepoint off of the os drive but that isnt really fixing anything..

I am apprehensive with running any sql queries as I am NOT familiar with SQL... This IS a production server and an accounting firm, so this is a bad time to crash their server.

I have a screen shot of the usage and will compare it in a couple of days to find where the growth is.. But I think 17 gb's is pretty large for sharepoint
Reply With Quote
  #7  
Old 02-23-2012, 08:37 PM
knc knc is offline
 
Join Date: Feb 2010
Location: Kingston, Ny
Posts: 342
knc can only hope to improve
Default

also they arent using exchange at all so I cant imagine the log files are getting out of hand there..
Reply With Quote
  #8  
Old 02-23-2012, 08:55 PM
bluecoast's Avatar
bluecoast bluecoast is offline
 
Join Date: Jun 2009
Location: FL
Posts: 132
bluecoast is on a distinguished road
Default

That file is the transaction log for the Sharepoint database. It keeps track of all the changes made in the event that a db restore is done. It is not the actual DB. There is a way to shrink the log by committing the changes to the DB, I think you need to install SQL server management studio(it can be run from a workstation rather than install on the server.)
Reply With Quote
  #9  
Old 02-23-2012, 09:18 PM
YeOldeStonecat's Avatar
YeOldeStonecat YeOldeStonecat is offline
 
Join Date: Nov 2011
Location: Southeast Connecticut
Posts: 7,472
YeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to beholdYeOldeStonecat is a splendid one to behold
Default

Can shrink it with native tools in SBS08
http://www.sharepointboris.net/2008/...big-reduce-it/

If you want the easy way....you can use Microsoft Fixit
http://support.microsoft.com/kb/2000544

Just click...accept....zip through the little wizard.

Grows like mad if Sharepoint isn't being backed up properly.
__________________
Resident "Geek on a Harley" doing IT in Southeast Connecticut
http://www.dynamic-alliance.com/
https://www.facebook.com/YeOldeStonecat
Reply With Quote
  #10  
Old 02-23-2012, 10:35 PM
MobileTechie's Avatar
MobileTechie MobileTechie is offline
 
Join Date: Oct 2009
Location: UK
Posts: 4,254
MobileTechie has a spectacular aura aboutMobileTechie has a spectacular aura about
Default

The method I use is:


Open SQL Server Management Studio Express and connect to:
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query - this will get SQL Server Management to find the relevant files for you.

Then paste this query in the window and execute it:

BACKUP LOG [dbname] WITH TRUNCATE_ONLY
Go
Use [dbname]
Go
DBCC SHRINKFILE([dbname_log],2)
Go

It's essentially the same as the 2nd link stonecat posted. I've done it scores of times and it's perfectly safe. It's not going to crash their server. Copy and paste the database names in so you know they're right.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:36 AM.


Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Technibble.com is based out of MELBOURNE, AUSTRALIA.