-
- Veteran
- Posts: 284
- Liked: 11 times
- Joined: Jan 06, 2011 8:33 am
- Contact:
Warning Message - periodically SQL Logfile Backup
Hello ,
We become the following Warning Message while backing up an SQL Database Logfile via Application Aware Processing : Failed to perform internal backup (baramundi): At least one full database backup must be performed before transaction log backup can be enabled This Database is set to Recovery Mode "Full" in Windows SQL Server.
Yesterday we make an Full Veeam Backup Job of the SQL Server which hosted this Database and after this the warning is gone, because we make an Full Backup of this Database with Veeam.
But after the next reverse incremental Backup in night the Warning Message appears again. I become also an Error Message in the SQL Database Logfile Backup which says : Transaction logs from some databases were not backed up for the last 21 intervals.
How can we solve this Problem ?
We become the following Warning Message while backing up an SQL Database Logfile via Application Aware Processing : Failed to perform internal backup (baramundi): At least one full database backup must be performed before transaction log backup can be enabled This Database is set to Recovery Mode "Full" in Windows SQL Server.
Yesterday we make an Full Veeam Backup Job of the SQL Server which hosted this Database and after this the warning is gone, because we make an Full Backup of this Database with Veeam.
But after the next reverse incremental Backup in night the Warning Message appears again. I become also an Error Message in the SQL Database Logfile Backup which says : Transaction logs from some databases were not backed up for the last 21 intervals.
How can we solve this Problem ?
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
Please contact technical support to investigate this, as it is advised to do with any technical issue you're seeing.
-
- Expert
- Posts: 179
- Liked: 8 times
- Joined: Jul 02, 2013 7:48 pm
- Full Name: Koen Teugels
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
is you're rentention of the log backups high enough , more the the time to take a veeam image bckuos every day and so a full SQL backup
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
Do you do any backups of the logs via native tools by any chance?
-
- Novice
- Posts: 5
- Liked: never
- Joined: Oct 31, 2019 8:11 am
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
Any news about this?
We´re getting the same error with our baramundi database.
We´re getting the same error with our baramundi database.
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
Can you please tell us if you back up this DB natively or just with Veeam? Also, how your backup job is configured in terms of transaction logs backup?
-
- Novice
- Posts: 5
- Liked: never
- Joined: Oct 31, 2019 8:11 am
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
We create the backup only via Veeam.
Retention: 1 days
advanced settings:
reverse incremental
enable application-aware processing
- require successful processing
- process transaction logs with the job
- backup logs every 15min
schedule:
daily at 20:00 everyday
Retention: 1 days
advanced settings:
reverse incremental
enable application-aware processing
- require successful processing
- process transaction logs with the job
- backup logs every 15min
schedule:
daily at 20:00 everyday
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
Did it start happening only recently or after enabling the transaction logs option? Did you try running full backup as it is stated in the message?
-
- Novice
- Posts: 5
- Liked: never
- Joined: Oct 31, 2019 8:11 am
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
A full backup is created every day at 8 p.m.
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
I'd recommend contacting support for a closer look then.
-
- Lurker
- Posts: 2
- Liked: 3 times
- Joined: Jun 21, 2021 1:27 pm
- Contact:
Re: Warning Message - periodically SQL Logfile Backup
Just for information if someone else runs into this issue:
There is a maintenance plan "Clean up database" inside the baramundi application which changes the recovery model of the database to SIMPLE. Run some maintenance tasks like Shrink database files and index maintenance. At the end the recovery model is configured back to FULL.
Therefore the backup chain gets resetted and transaction log backup isnt working because of a missing full backup.
Workaround is to change the maintenance task inside the baramundi application.
There is a maintenance plan "Clean up database" inside the baramundi application which changes the recovery model of the database to SIMPLE. Run some maintenance tasks like Shrink database files and index maintenance. At the end the recovery model is configured back to FULL.
Therefore the backup chain gets resetted and transaction log backup isnt working because of a missing full backup.
Workaround is to change the maintenance task inside the baramundi application.
Who is online
Users browsing this forum: No registered users and 92 guests