• SQL Server has three recovery models:

    Simple: This model minimally logs most transactions.

    Full: logs all transactions an retains all the transaction log records until after they're backed up.

    Bulk-Logged: minimally logs bulk operations, such as index creation, bulk inserts, etc.

    How you combine any of these models with full or differential backups will determine how precise your backup could be.