Post reply

C:\ drive full in sql server box

  • May 22, 2008 at 3:29 pm

    #123987

    hi guys in my sql server box i have the C:\ drive which contains the documents and settings ,program files, and windows folders and then my D:\ drive which contains my databases with the data and log files. My C:\drive is almost full only 10 MB left but i don't see why, when i go to the folders inside my C drive i only add up up to 5 GB when the total GB i could have is 13 GB, nothing new has been installed in this box, what can i do? should i defragment?

  • May 22, 2008 at 4:57 pm

    #819428

    have u check the temp files, and u can try for the hiden files also.

    ..>>..

    MobashA

  • May 22, 2008 at 8:35 pm

    #819467

    yes i went to the temp folder and it is empty and also showing 0 mg, i also clicked on the show hidden files and nothing. :ermm:

  • May 23, 2008 at 2:06 am

    #819525

    Check your drive for bad sectors because if your drive has bad sectors it will not be able to use that space.

    Basit Ali Farooq
    MCITP Database Administrator
    Microsoft Certified Professional Developer (Web Applications)
    Microsoft Certified Database Administrator
    Microsoft Certified Systems Engineer
    Microsoft Certified Systems Administrator
    CIW Security Analyst
    Cisco Certified Network Associate

  • May 23, 2008 at 3:43 am

    #819556

    you may want to download a program called spacemonger, if you download version 1.4 it was the last free version. this will show a graphical display of your files and you can instantly see which files are filling up your disk. treesize also does a similar thing.

    Edit - add link

    http://www.softpedia.com/get/System/Hard-Disk-Utils/SpaceMonger.shtml

  • May 23, 2008 at 6:54 am

    #819625

    Thank you, i am a little skeptical about installing third party software in the box, is there another way? , also i checked this morning and in my temp folder there is 15 MB. How do i check my drive for bad sectors?

  • May 23, 2008 at 6:55 am

    #819626

    its not an install, its simply an exe that runs, you dont install anything.

  • May 23, 2008 at 7:20 am

    #819638

    I don't thave the internet enabled in the box. :blink:

  • May 23, 2008 at 7:21 am

    #819643

    download it from your machine and copy it over, its tiny

  • May 23, 2008 at 7:40 am

    #819667

    nice.... thanks! ok i did, my windows and program files taking total 15 GB, and then the pagefiles.sys taking 2,345,555,496 bytes..what can i do about that?. I heard also that it have something to do with the secondary memory reserved for this drive?.

    Should i try defragmenting the C:drive? If so, sql server service, agent need to be off for this correct?

  • May 23, 2008 at 7:47 am

    #819675

    You know, you could be severely fragmented too. That'll eat up a lot of space.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • May 23, 2008 at 8:05 am

    #819691

    im confused as to why spacemonger isnt showing the space correctly. Ive never seen it show an incorrect amount of free space, and by the sounds of it half your disk should be free. Is spacemonger registering the size of your drive correctly on the top bar?

  • May 23, 2008 at 8:14 am

    #819698

    yes it is, it is showing 17.3 GB total , 20.9 MB free. Does the Pagefile.sys have to be that big? i am running a windows xp with 1.99 GB of RAm. If so, can i move it to the D drive? Or maybe it is better for now just to move the C:\windows\temp (it is only 100 Mg) folder to the D drive for some space until i can add more?

  • May 23, 2008 at 8:44 am

    #819728

    how big is your page file currently?

  • May 23, 2008 at 8:49 am

    #819735

    around 2.3 GB, can i move the c:\windows\servicepacks to the d drive?

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply