title: Unable to shrink Data File in SQL Server (Taking too much time)
body: <p>I am using :</p>
  
  <p><strong>SQL Server 2016 Standard edition</strong></p>
  
  <p><strong>Windows Server 2012 R2 (Standard)</strong></p>
  
  <p><strong>Database Size:</strong> 1.4TB</p>
  
  <p><strong>Used space from the Primary Data File:</strong> 587GB</p>
  
  <p><strong>Unused space in a Primary Data File :</strong> 852GB</p>
  
  <p><strong>Recovery Model:</strong> Simple</p>
  
  <blockquote>
    <p>I am trying to shrink the Data file to 687GB by using a following Command:</p>
  </blockquote>
  
  <pre><code>USE [TestDB]
  GO
  DBCC SHRINKFILE (N'TestDB' , 687017) 
  GO
  </code></pre>
  
  <p>And there is no blocking and no other activities are happening on this database.</p>
  
  <p><strong>The above shrink operation is been in the process since last 19hrs and still not completed.
  So can anyone tell me what needs to be done at this point of time.</strong></p>
  
  <p><strong>How much time should be taken by this shrink operation?</strong></p>