Execute the following Microsoft SQL Server T-SQL scripts in SSMS Query Editor to change recovery model.

Transaction log backups are not meaningful in SIMPLE mode. Full database backups can be used for recovery when in SIMPLE mode. In FULL recovery point-in-time restore is possible as long as the backup files (full, transaction, optionally differential) available.

USE master;

GO

-- Set recovery model to SIMPLE

ALTER DATABASE AdventureWorks

SET RECOVERY SIMPLE;

GO

-- Command(s) completed successfully.

-- Set recovery model to FULL

ALTER DATABASE AdventureWorks

SET RECOVERY FULL;

GO

-- Command(s) completed successfully.