SQL Server Recovery Models: A Quick Guide A recovery model in a Structured query language (SQL) Server manages the transaction logs and handles how they are logged, backed up, and restored.For detailed information on backing up SQL Server through SQL Server Management Studio, see http://msdn.microso...