Space available 1644MB

• JMI

  SSChampion

  Points: 11831

  More actions

  May 26, 2004 at 2:18 pm

  #152157

  In EM it shows that:

  Size:  5036MB

  Space available:  1644MB

  Even if click on Shrink database

  db size remains the same.

  My question is if there is so much space available

  why it doesn't compress it?

  I also tried DBCC SHRINKFILE(SLP_Data,4000)

  but it hangs for more than 5 minutes so click cancel.

• May 31, 2004 at 8:00 am

  This was removed by the editor as SPAM

• billkamp

  SSC Enthusiast

  Points: 107

  More actions

  June 4, 2004 at 9:29 am

  #509042

  Have you tried DBCC SHRINKFILE in single user mode? It might be possible that pending transactions and/or tasks are inhibiting the shrinkage.