Clean SQL log File.

use teamcity_sj_self;
SELECT file_id, name, type_desc, physical_name, size, max_size  FROM sys.database_files; 
ALTER DATABASE teamcity_sj_self
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (teamcity_sj_self_log, 1)
GO
ALTER DATABASE teamcity_sj_self
SET RECOVERY FULL
SELECT file_id, name, type_desc, physical_name, size, max_size  FROM sys.database_files; 
select name, log_reuse_wait_desc from sys.databases 

Note: Sometimes the log file name might be different. So check them in the first query result.

Clean bin/obj/packages folders

Get-ChildItem .\ -include bin,obj,packages -Recurse | ForEach-Object ($_) { Remove-Item $_.FullName -Force -Recurse }

Deployed At05-Oct-2024 01:51 PM +0000
Santosh Jallapuram on Stack Overvflow