SQL Server supports three recovery models: Simple, Bulk-Logged, and Full. The Simple model does not support transaction log backups and is suitable for scenarios where data loss is acceptable.