The hard disk has only 7mb of space left. The boss is out of the office what do I do?

The hard disk has only 7mb of space left.  The boss is out of the office what do I do?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Clear unneeded stuff from the hard disk.
Try to use CCLeaner to remove the unwanted disk space.
Try compress disk utility in for that disk.

If the above doesn't help, elaborate your question in details.

John Nash
apart from calling the boss, i think you can delete temporary files, empty the recycle bin, and perform disk cleanup.

to perform disk cleanup, open "my computer" and right on the drive (which has no free space).
select "properties" - within the general tab, there will be a button called "disk cleanup"

click it.

select all the available options in "files to delete" and click "ok"

see if there is any increase in available disk space, and post back.
Mr_ShawAuthor Commented:
it seems to be the SQL backup files are taking up a lot of space. What should i do?
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Kevin CrossChief Technology OfficerCommented:
Which hard disk is it?  (hoping you have application, data and logs on separate disks)

What is consuming the space.  You can check if it is backups and transaction log backups as you can probably move some of the older ones off to an external storage device or tape and then remove them from the disk (***** be very careful deleting *****).  If you have extra databases that are really not important -- sandbox kind of databases that you don't ever really need to recover from you can prune those by shrinking file(s) -- sometimes those are the most space hogs because we tend not to back those up often so the transaction logs don't get truncated so you are sitting with Gigs of space taken up by a db that can run on a few Megs of storage. :)

Again, be careful which databases you are pruning as you only want to do this on databases where there is no importance to you if data is lost.

Make sure it isn't anything silly like dowloads or additional files placed on a drive temporarily and forgotten to be moved.  If you recently had a blue screen, that after troubleshooting/resolution of the issue the memory dump file is still not sitting on the hard drive taking up Gigs of space.  

Just some thoughts...

Good luck!
Kevin CrossChief Technology OfficerCommented:
Ah, I guess I took too long to type, 3 posts now.  Think I covered your question on the backup files.  You can move them to external storage OR if (big if) you know for sure you don't need them like you have a 30 day retention but backups back for 2 years then delete oldest backups first.
Hello Mr Shaw,

You can temporary move the pagefile to another partition if you have on on the computer :;en-us;307886&x=6&y=12

Kevin CrossChief Technology OfficerCommented:
That will require a reboot to actually take effect and judging by the panic I would have thought this to be a production system that you could not take down and needed to get users connected back quickly from getting error messages relating to tempdb not having enough space to do its job or some other symptom space related...

Again, my hope is you don't have page files on the same disk / volume as your SQL data. *sigh*
Hello mwvisa1,

If it's a production server I think reboot is not a problem :))
Kevin CrossChief Technology OfficerCommented:
But unnecessary, when cleaning up the space being used by superfluous items like old backup files, etc. Then it is a big problem as you are compounding the issue unnecessarily.  

I would fix the issue as quickly as possible for the users then schedule down time to properly setup the system as I would not want pagefile on the same disk that SQL is trying to write transaction logs or my data to anyway.  So guess I shouldn't harp too much on the reboot when my main point is that on a production SQL system I would think it unlikely the pagefile is on the SQL drive to begin with.  Maybe that is just me though. :)

What happens when you reboot and application servers whose services have to start after SQL's now have to be restarted or worst the servers rebooted.  If you are in a small environment have it -- the company I am at now I can probably get on a PA and say I am taking everything down for 15 minutes thanks -- but I have also worked for 50k+ employee companies where you would lose you job for doing something as disruptive as that when there were alternatives.  Guess if you are in that company, you probably wouldn't get to 7MB or only have one person (boss) who knew what to do but I like to follow good corporate practices no matter the size of the organization I am controlling...  Again that is just my habits from the world I grew up in.

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
No, you totally right. But I'm sure ( I hope ^^; ) 50k+ employee companies don't let a non DBA user with a workstation + MS SQL with only 7mb with VERY important stuff on it.

Wait and see what Mr Shaw give us as feedback

CCLeaner (or other cleaner) should use more than 7mb to be installed.
Another solution should to MOVE (another partition or thumb drive) Temporary Internet Files Manually :
Mr_ShawAuthor Commented:
Thanks for the points! See you soon!

Heu... No feedback ? :o(
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.