<div>
<blockquote>
We truncated a system log table that was no longer used. 
</blockquote>
What's a &quot;system log table&quot; and how did you truncate it?<br />
<br />

<blockquote>
Now, I try to shrink in the datafile to recover a portion of the space, however, the process does not end, I left a shrink running for 3 days and it did not finish.
</blockquote>
How big is the datafile and how did you shrink it?
</div>


> We truncated a system log table that was no longer used.

What's a "system log table" and how did you truncate it?



> Now, I try to shrink in the datafile to recover a portion of the space, however, the process does not end, I left a shrink running for 3 days and it did not finish.

How big is the datafile and how did you shrink it?

<div>
Thank you.<br />
<br />
It has helped a lot with the references mentioned.
</div>


Thank you.

It has helped a lot with the references mentioned.

<div>
Welcome Alex.<br />
<br />
Regards,<br />
Pawan
</div>


<div>
<div class="content wysiwyg-content">
Good night<br />
<br />
&nbsp;I have the following problem: We truncated a system log table that was no longer used. Now, I try to shrink in the datafile to recover a portion of the space, however, the process does not end, I left a shrink running for 3 days and it did not finish.<br />
<br />
&nbsp;Does anyone have any idea how I can recover this space?
</div>
</div>


Good night

 I have the following problem: We truncated a system log table that was no longer used. Now, I try to shrink in the datafile to recover a portion of the space, however, the process does not end, I left a shrink running for 3 days and it did not finish.

 Does anyone have any idea how I can recover this space?

shrink datafile Sql server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.