C: drive low on an sql web server

WHat files or logs can I delete when my C: crive gets below .400 MB ? on the server ? THanks

windows 2003 sql
mado5150Asked:
Who is Participating?
 
Hypercat (Deb)Connect With a Mentor Commented:
You could also move the SQL data files to a different drive or partition on the same server. Do you have any other drives or partitions on this server with more available disk space?
0
 
ambidextrousCommented:
When you say "SQL Web Server"... are you running Microsoft SQL Server AND IIS on the same machine?

If so, refer to this article to locate your IIS logs and remove them:

http://portal.smartertools.com/KB/a154/where-are-my-iis-log-files-stored.aspx

Alternatively, if you are running large transactions and your database(s) are on the C:\.  Use SQL Management Studio to "Shrink" the databases and logs.

Just a couple of thoughts...
0
 
mado5150Author Commented:
Looks like there is no IIS installed
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
ambidextrousCommented:
mado5150 - usually when my servers are running low on space I usually install and run the following utility.

http://windirstat.info/

It will tell you where most of the space is being eaten up.  Could be Windows Updates, Databases, Applications, etc...  but this gives a great visual.
0
 
arnoldCommented:
Check the sql server through SSMS and see where the databases, transaction log, backups, etc. are
I think leew or someone else within EE has an article on where one could find files that are not needed on C: or can be moved to a different location
c:\windows\$NT update folders
c:\windows\ie7update
c:\windows\ie7
c:\windows\ie8
c:\windows\ie8updates
c:\windows\softwaredistribution\downloads
check the user profiles %allusersprofile%

c:\windows\tmp etc.
0
 
quarky42Commented:
I really like ccleaner for cleaning out temporary files.   You may be able to uninstall programs and reinstall them using custom options pointing them to the D:\ drive if you have another hard drive installed.

CCleaner: http://www.filehippo.com/download_ccleaner/

You can see how big various folders are by using something like this:
http://download.cnet.com/TreeSize-Free/3000-2248_4-10139400.html?tag=mncol;1

Don't just delete folders willy nilly, of course, but you can try and find out what folders are the biggest culprits and find out if the files are necessary.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.