USE Back2021;  

GO  

-- Truncate the log by changing the database recovery model to SIMPLE.  

ALTER DATABASE Back2021  

SET RECOVERY SIMPLE;  

GO  

-- Shrink the truncated log file to 1 MB.  

DBCC SHRINKFILE (Back2021_Log, 1);  

GO  

-- Reset the database recovery model.  

ALTER DATABASE Back2021  

SET RECOVERY FULL;  

GO

USE otodoc;  

GO  

-- Truncate the log by changing the database recovery model to SIMPLE.  

ALTER DATABASE otodoc  

SET RECOVERY SIMPLE;  

GO  

-- Shrink the truncated log file to 1 MB.  

DBCC SHRINKFILE (otodoc_Log, 1);  

GO  

-- Reset the database recovery model.  

ALTER DATABASE otodoc  

SET RECOVERY FULL;  

GO  

PROCEDÜRE OLARAK YAPARSAN C# DA DİREKT ÇAĞIRABİLİRSİN

HATA VEREBİLİR AMA TEMİZLER
C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA

CREATE proc shrinkdataproc(@dbname nvarchar(500) ) as begin

-- Kullanımı -> exec shrinkdataproc @dbname='Back2019'

declare @komut nvarchar(MAX)

declare @database_log  nvarchar(MAX)

Set @database_log = (Select name From sys.database_files Where type_desc = 'LOG')

set @komut = '

AlTER DATABASE '+@dbname+' SET RECOVERY SIMPLE WITH NO_WAIT

DBCC SHRINKFILE('+@database_log+')

ALTER DATABASE '+@dbname+' SET RECOVERY FULL WITH NO_WAIT

'

Print(@komut)

exec (@komut)

set @komut = 'DBCC  SHRINKDATABASE(N'''+@dbname+''')'

Print(@komut)

exec (@komut)

end