Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


SQL Server 2008 will not shrink transaction log
If SQL Server "Shrink Files" does not shrink your transaction log, try the following:

1. Perform a full backup of the database. If you check the shrink tool, you will see there is now available free space in the log file. However, clicking OK will not reduce the size of the log.

2. Perform a second full backup of the database.

3. Now, run the shrink tool on the log file and the log file should reduce in size to almost 0MB.

I don't know if this is a bug or feature of SQL Server 2008 - but it is unintuitive.

Created By: amos 12/7/2012 12:49:43 PM