Home Forums SQL Server 2008 SQL Server 2008 - General space issue RE: space issue

  • May 17, 2013 at 4:50 am

    #1616113

    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]