SIMPLE
Changes since the most recent backup are unprotected.
No log backups required.
Does not support Log shipping, Always On or Database mirroring.
FULL
Can recover to a specific point in time.
Log backups required.
Supports Log shipping, Always On and Database mirroring.
SELECT name, recovery_model_desc
FROM sys.databases;
GO
Right click your database in the Object Explorer and select Properties...
USE [master] ;
ALTER DATABASE [myDatabase] SET RECOVERY FULL ;
Take a backup.
Schedule Transaction Log Backups
Navigate to the Properties screen shown in the Check section above and select FULL from the Recovery model dropdown.
Take a backup.
Schedule Transaction Log Backups
ALTER DATABASE [myDatabase] SET RECOVERY SIMPLE;