" Cannot truncate SQL logs for database: model " Veeam Backup

Was setting up Veeam for one of our clients and found the below Warning message in a SQL Server backup. The below steps helped me resolve the issue. Hope it helps you too..

Issue:
 You will see the below warning message in a Veeam backup Job with SQL VMs. " Failed to truncate Microsoft SQL Server transaction logs. Details:  Error code: 0x80004005 " .

The complete error message is a below:

Failed to truncate Microsoft SQL Server transaction logs. Details:  Error code: 0x80004005
Failed to invoke func [TruncateSqlLogs]: Unspecified error. Failed to process 'TruncateSQLLog' command.
Failed to truncate SQL server transaction logs for instances:  . See guest helper log. .
 Error code: 0x80004005
Failed to invoke func [TruncateSqlLogs]: Unspecified error. Failed to process 'TruncateSQLLog' command.
Failed to truncate SQL server transaction logs for instances:  See guest helper log.

Verification:

1) You can open the Guest Agent log file located in the below location " C:\ProgramData\Veeam\Backup\VeeamGuestHelper***.log " in the SQL VM and verify if you are seeing the  below message :

 5604                                  Major version: 12

 5604                                  Database tempdb has not been backed up yet.

 5604                                  Database found: master. Recovery model: 3. Is readonly: false. State: 0.

 5604                                  Database found: tempdb. Recovery model: 3. Is readonly: false. State: 0.

 5604                                  Database found: model. Recovery model: 1. Is readonly: false. State: 0.

 5604  WARN                    Cannot truncate SQL logs for database: model. Code = 0x80040e14

 5604  WARN                    Code meaning = IDispatch error #3092

 5604  WARN                    Source = Microsoft OLE DB Provider for SQL Server

 5604  WARN                    Description = BACKUP LOG cannot be performed because there is no current database backup.

 5604  WARN                    No OLE DB Error Information found: hr = 0x80004005

 5604                                  Database found: msdb. Recovery model: 3. Is readonly: false. State: 0.

 5604                                  Database found: TEST. Recovery model: 1. Is readonly: false. State: 0.

 5604                                  Database found: omar. Recovery model: 1. Is readonly: false. State: 0.

 5604                              Truncating database logs (SQL instance: ). User: XXXXX.. Ok.

 5604                              Truncating database logs (SQL instance: ). User: NT AUTHORITY\SYSTEM.

5604  INFO                            Connecting to mssql, connection string: Provider='sqloledb';Data Source='(local)';Integrated Security='SSPI';Persist Security Info=False, timeout: 15

Solution :

 The resolution to the issue was pretty simple:

1) Login to SQL DB using SQL Management Studio.

2) GO to system database => Right-click the Model Database => Tasks => Backup = > Provide a name for the backup and initiate a backup.

3) Once a initial backup was taken the Warning message disappears.

XX