How to set the Recovery Model to Simple in MS SQL Server?

Question

My transaction logs on MS SQL Server are consuming the disk space.  How can I set the Recovery Model to Simple in MS SQL Server?

Answer 1

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?