1.2k questions
1.4k answers
361 comments
339 users
Follow the arrows in Microsoft SQL Server Management Studio to change the recovery model to simple.
If you also nee to clean up the transaction logs see this question:
https://www.qvera.com/kb/index.php/541/how-shrink-sql-server-transaction-logs-for-the-qie-database?show=542#a542
Also see these related questions
How to shrink MS SQL Server transaction logs for the QIE database?
How do I shrink the h2 database file after removing thousands of errors?
How should I resolve an "Out of Disk Space" error?
How to check the current and max size of the databases on SQL Server
How to reclaim disk space after purging messages with a MariaDb/MySql database?