How do you switch an active SQL Server database into Simple Recovery Mode

Question

I've had some logging problems and based on the way the application works we don't need full recovery mode, which will help us with our logging.

How do I switch the database into simple recovery mode?

Answer 1

You can do it in SQL Managment Studio by right-clicking the database, choosing Properties, selecting Options in the menu on the left and changing the Recovery Model drop-down to Simple.

In T-SQL the command is:

ALTER DATABASE [MyDatabase] SET RECOVERY SIMPLE