<div>
<div class="content wysiwyg-content">
What is the best and safest way to shrink the mdf and ldf files of my databse? I use the following command:<br />
<br />
DBCC SHRINKFILE(sfs_dat, truncateonly)<br />
DBCC SHRINKFILE(sfs_log, truncateonly)<br />
<br />
I have also used this command, but I think truncateonly is healthier. Is that correct?<br />
<br />
DBCC SHRINKFILE(sfs_dat, 1)<br />
DBCC SHRINKFILE(sfs_log, 1)<br />
<br />
I see some people recommend this command. Why the backup log command does that force sqlserver to do some cleanup internally or something?<br />
<br />
DBCC SHRINKFILE(&lt;TransactionLog<wbr />Name&gt;, 1)<br />
BACKUP LOG &lt;DatabaseName&gt; WITH TRUNCATE_ONLY<br />
DBCC SHRINKFILE(&lt;TransactionLog<wbr />Name&gt;, 1) <br />
<br />
and final question: Is the only difference between DBCC SHRINKFILE and DBCC SHRINKDATABSE, that DBCC SHRINKDATABASE does all files?<br />

</div>
</div>


What is the best and safest way to shrink the mdf and ldf files of my databse? I use the following command:

DBCC SHRINKFILE(sfs_dat, truncateonly)
DBCC SHRINKFILE(sfs_log, truncateonly)

I have also used this command, but I think truncateonly is healthier. Is that correct?

DBCC SHRINKFILE(sfs_dat, 1)
DBCC SHRINKFILE(sfs_log, 1)

I see some people recommend this command. Why the backup log command does that force sqlserver to do some cleanup internally or something?

DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1) 

and final question: Is the only difference between DBCC SHRINKFILE and DBCC SHRINKDATABSE, that DBCC SHRINKDATABASE does all files?


best way to shrink database file sizes

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.