Shrinking db_ApexCentral_Log.ldf Using SQL Commands

Backup the Apex Central database using the SQL Server Management Studio.

From the available databases, select the db_ApexCentral database.

Execute the following SQL Script:

DBCC shrinkfile('db_ApexCentral_log', 10)

Verify the size of db_ApexCentral_Log.LDF is less than 10MB.

If db_ApexCentral_Log.LDF was not reduced in size, use the following SQL command to identify the Database Recovery Mode used:

SELECT name as DatabaseName, DATABASEPROPERTYEX(name, 'Reco
very') as RecoveryMode FROM master.dbo.sysdatabases where n
ame='db_ApexCentral'

If the Database Recovery Mode is FULL, execute following SQL script:

-- Truncate the log by changing the database recovery model
 to SIMPLE.
ALTER DATABASE db_ApexCentral
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 10 MB.
DBCC SHRINKFILE (db_ApexCentral_Log, 10);
GO
-- Reset the database recovery model.
ALTER DATABASE db_ApexCentral
SET RECOVERY FULL;
GO

For detailed information on shrinking SQL databases and SQL commands, refer to the Microsoft SQL Server Administration documents.