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??

  • VossSQL (1/3/2014)


    Hi.

    I understand that SHRINK data/log files should be the last option due to all problems it generates. But how can I proceed on the following situation?

    SQL Server 2008 R2. One database has only the primary filegroup. This filegroup has 111 gb of space reserved and it is using only 33 gb. Application team said this database won't grow more than 50 gb. So we want to reclaim the rest of space that this database will never use. How can I do this without shrinking the primary filegroup? Or is shrinking justified in this specific situation?

    Thanks!

    I'd be tempted to perform a one off shrink to around 75-80GB, that'll hopefully leave enough space for the index rebuilds and natural growth of the data.

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

    "Ya can't make an omelette without breaking just a few eggs" 😉