0

How can I get release unused space to the OS ?

enter image description here

I tried 

DBCC SHRINKDATABASE(QlikDataWarehouse, truncateonly)

But nothing happens , any suggestion ?

jarlh
  • 42,561
  • 8
  • 45
  • 63
user3548593
  • 499
  • 1
  • 7
  • 22
  • 2
    Possible duplicate of [How do I shrink my SQL Server Database?](http://stackoverflow.com/questions/439071/how-do-i-shrink-my-sql-server-database) – Tanner Oct 16 '15 at 13:35

1 Answers1

0

Your truncateonly parameter doesn't allow SQL Server to rewrite data to free up space. Back up the database (necessary to allow the transaction log to be truncated), then shrink it without the truncateonly option.

Robert Calhoun
  • 4,823
  • 1
  • 38
  • 34