space issue

  • We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

  • ramyours2003 (5/17/2013)


    We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

    Delete something! 😉

    http://msdn.microsoft.com/en-us/library/ms189493.aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • Lolz. Start taking backups and put a strategical purging mechanism in place for tables to purge old data. The data will be saved in the backups taken. No big deal. 🙂

  • shrink DataFiles

  • shrink DataFiles

  • Eugene Elutin (5/17/2013)


    ramyours2003 (5/17/2013)


    We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

    Delete something! 😉

    http://msdn.microsoft.com/en-us/library/ms189493.aspx

    ROFL - that put a smile on my face!

    On a serious note - if you do go down the ShrinkFile route then make sure you reindex afterwards as you could run into fragmentation issues after it's finished.

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • no space in data file , unable to shirnk.

  • ramyours2003 (5/17/2013)


    no space in data file , unable to shirnk.

    You need to purge some old data first - whether that is permanently deleting it or moving it to another db on another disk or what ever, you need to remove data from that db before you shrink it

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • Delete data, add more space or move stuff to another drive.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • If you have an (extremely) large table(s), compress them [if on Enterprise Edition], particularly if they are (almost) never used, such as log/audit tables, etc..

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

  • ramyours2003 (5/17/2013)


    We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

    SHRINK DATABASE, SHRINK FILE, add disks, partition the data in seperate databases onto other disks, check and rebuild/reorg Indexes, use compression, spread the databases to other servers.....the Options are endless....

    but most of all, learn about what you are working with! Not just the databases but also the Software that they are hosted on!

  • if all db's .mdf files are stored in this drive, you need to do DB Maintenance for all databases except that DB

    DB Maintenance

    ----------------

    shrink database

    Delete backup history

    and job history

    Rebuild index

    then you will get some free space in Drive. so you can do Shrink database and Rebuild index for database, which you are getting space issue in .mdf file.

    or finally if you have another drive in the same server, you better to add .ndf files.

  • check all the size of the table try to archival the old data

Viewing 13 posts - 1 through 12 (of 12 total)

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