Home Forums SQL Server 2008 SQL Server 2008 Administration Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again?? RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

  • January 5, 2014 at 10:55 pm

    #1677645

    Thanks Perry. I did exactly that. I left the file with 75 gb reserved and it is only using 33 gb now in order to have some space for reindexes and data growth just in case.

    Before I ran the shrink command I analyzed the fragmentation and then I did it again after the shrink. Just few indexes were affected and I only rebuilt those.

    Thanks! 🙂