Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
Article ID: 272318 - View products that this article applies to.
This article was previously published under Q272318
Shrinking the log in SQL Server 2000 is no longer a deferred operation. A shrink operation attempts to shrink the file immediately. However, in some circumstances it may be necessary to perform additional actions before the log file is shrunk to the desired size.
When DBCC SHRINKFILE is run, SQL Server 2000 shrinks the log file by removing as many virtual log files as it can to attempt to reach the target size. If the target file size is not reached, SQL Server places dummy log entries in the last virtual log file until the virtual log is filled and moves the head of the log to the beginning of the file. The following actions are then required to complete the shrinking of the transaction log:
REFERENCESFor more information, see the Shrinking the Transaction Log and DBCC SHRINKFILE topics in SQL Server 2000 Books Online.
For additional information about shrinking the transaction log in SQL Server 7.0, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256650/EN-US/ )INF: How to Shrink the SQL Server Transaction Log