Shrink Database LDF & MDF Files

Shrink Database LDF File

USE 'ContentDatabase';
GO
BACKUP LOG 'ContentDatabase' WITH TRUNCATE_ONLY;
GO
DBCC SHRINKFILE ('ContentDatabase_log', 100);


Shrink Database MDF File

USE 'ContentDatabase';
GO
SP_HELPDB 'ContentDatabase';
GO
EXEC sp_spaceused @updateusage = 'true';
GO
DBCC SHRINKFILE ('ContentDatabase', 100)
GO
EXEC sp_spaceused