In the following command I try to shrink my log file down to 1GB. DBCC SHRINKFILE (‘SalesHistory_Log’, 1000) Also, make sure that your databases are NOT set to auto-shrink.

So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...

Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window. Type the ...

I have found some information online that says I need to use SQL server to shrink this file. I did not have SQL server installed on the server.