Microsoft KB Archive/814574

= Error message when you shrink the transaction log file of a database in SQL Server: &quot;Cannot shrink log file ...&quot; =

Article ID: 814574

Article Last Modified on 5/31/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-



SYMPTOMS
When you run a DBCC SHRINKFILE command in SQL Query Analyzer to shrink the specified transaction log file of a database, the transaction log file does not shrink, and you may receive the following error message:

Cannot shrink log file  because total number of virtual log files cannot be fewer than 2.



MORE INFORMATION
When a transaction log file has two virtual log files, you cannot shrink the transaction log file by using the DBCC SHRINKFILE command.

