Post reply

Very Low Disk space

  • April 20, 2010 at 9:55 pm

    #218140

    Hi All,

    One of my Dev server has very low disk space on my H Drive(One among 3 drives)

    I need to free out the space in order to make sure my server doesnt hungup.

    Any suggestions on best practices to get the space.

    My Plan is to shrink the DB's on h drive using DBCC SHRINKDATABASE('DB',0,NOTRUNCATE)

    AND THEN REBUILD INDEXES AND THEN finally use disk defrag at OS level.

    I would also request any generic scripts and commands to get information regarding the

    space occupied and free available space for all DB's on my server

    T would really appreciate if you can provide me commands and generic scripts

    Thanks in advance.

  • April 21, 2010 at 12:34 am

    #1155119

    You can add more files to the file group. Files should be on different drive space. you can shrink the file to empty the file. this will move the data to other files in the file group... this is just hint.. you can think on this way to manage the space.

  • April 21, 2010 at 4:39 am

    #1155243

    Check this link :

    http://qa.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/

  • April 21, 2010 at 7:31 am

    #1155331

    Thanks very much for the reply..... thats really helpfull.

Viewing 4 posts - 1 through 3 (of 3 total)

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