SQL Server backup and restore processes go within the context of a database recovery model which defines the following:
- What types of backups and what restore scenarios will be supported for the database
- How the transaction log should be handled for that purpose
Microsoft SQL Server supports several logging and recovery models for its databases: simple, full, and bulk-logged.
- With simple recovery model specified for your database, you will be able to restore it only to the selected restore point; SQL Server will automatically truncate logs, and Veeam backup configuration will not affect any of them.
- With other models (full and bulk-logged), database transaction logs will not be truncated automatically by SQL Server, and Veeam offers different processing options for them.
To discover logging and recovery model for the database which you plan to backup and restore, use SQL Server Management Studio or contact your database administrator.
To read more about different logging and recovery models, refer to the Recovery Models (SQL Server) MSDN article.