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.
1 comment:
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
Post a Comment