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

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?
0
Mr_Shaw
Asked:
Mr_Shaw
  • 4
  • 4
  • 2
  • +2
4 Solutions
 
johnnash1180Commented:
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
0
 
hatheharikenCommented:
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.
0
 
Mr_ShawAuthor Commented:
it seems to be the SQL backup files are taking up a lot of space. What should i do?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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!
0
 
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.
0
 
leakim971PluritechnicianCommented:
Hello Mr Shaw,

You can temporary move the pagefile to another partition if you have on on the computer : http://support.microsoft.com/?scid=kb;en-us;307886&x=6&y=12
You may TEMPORARY change its size too. This will affect performance of the PCSERVERWORKSTATIONOFYOURBOSSOUTOFOFFICEDURINGENDOFYEARASUSUAL

Regards.
0
 
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*
0
 
leakim971PluritechnicianCommented:
Hello mwvisa1,

Assuming Mr Shaw only have 7mb on the "SERVER&WORKSTATIONOFYOURBOSSOUTOFOFFICEDURINGENDOFYEARASUSUAL" drive
If it's a production server I think reboot is not a problem :))
0
 
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.
0
 
leakim971PluritechnicianCommented:
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 :  http://support.microsoft.com/kb/260897
0
 
Mr_ShawAuthor Commented:
thanks
0
 
leakim971PluritechnicianCommented:
Thanks for the points! See you soon!

Heu... No feedback ? :o(
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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