Your C drive is full !! On Shrink File SQL Server For Cases of Low disk space in C Drive

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



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


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


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


USE DX_PROD_CCL_backup;
GO
ALTER DATABASE DX_PROD_CCL_backup
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (GM_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE DX_PROD_CCL_backup
SET RECOVERY FULL;
GO

-- DX_PROD_CCL_backup

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

/*
USE tempdb;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE tempdb
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (tempdb_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE tempdb
SET RECOVERY FULL;
GO
*/