Cleanup Database Log
Query
use <OTCSdatabasename>
alter database <OTCSdatabasename> set recovery SIMPLE with NO_WAIT
Go
alter database <OTCSdatabasename> set recovery FULL with NO_WAIT
Go
DBCC SHRINKFILE(<Database Logical name LOG>,200)
Go
Database Name
![](https://coenraadict.nl/wp-content/uploads/2020/12/image-8.png)
Logical Name
![](https://coenraadict.nl/wp-content/uploads/2020/12/image-9.png)
![](https://coenraadict.nl/wp-content/uploads/2020/12/image-10.png)
Voorbeeld
![](https://coenraadict.nl/wp-content/uploads/2020/12/image-12.png)