Sunday, 14 August 2016

" 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

1 comment:

Anonymous said...

Excellent beat ! I would like to apprentice whilst you amend your web site, how can i subscribe for a
weblog website? The account helped me a applicable deal.
I had been tiny bit acquainted of this your broadcast provided vivid transparent concept