increments until it reaches a target free space limit. Run this script in the database with the file to be shrunk. 1. Set @DBFileName to the name of database file to shrink. 2. Set @TargetFreeMB to ...

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.

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 ...

Shrink vCenter Database. Update: For vCenter Server 5.1 and 5.5, see the To truncate all performance data from vCenter Server 5.1 and 5.5 section in Reducing the size of the vCenter Server database ...