Error Message

V-79-65323-4305 - An error occurred on a query to database DBNAME.
V-79-65323-4305 - The log in this backup set begins at LSN xxxxxxxxxxxxxxxxxxxxxxxxxxxx, which is too recent to apply to the database. An earlier log backup that includes LSN xxxxxxxxxxxxxxxxxxxxxxxxxxx can be restored.

When full and incremental/log backups are performed of SQL databases using the Backup Exec SQL agent, a point in time restore job can be run and backup sets will be automatically restored to roll log transactons up to the date/time selected.  If a SQL database backup outside of the Backup Exec SQL agent is performed, it can interrupt this backup sequence and prevent point in time restores for periods of time. This interruption may or may not fail a backup based on these two scenarios:

 - If this outside backup occurs between a Backup Exec SQL agent incremental backup and its following full backup, there will be no backup failure because the following full backup will reset the backup sequence with the baseline full backup.  An interruption to the Backup Exec SQL agent backup sequence like this will prevent a point in time restore where the point in time selected is between the incremental and full backups.

 - If the outside backup occurs between a Backup Exec SQL agent full and one of its following incrementals, the incremental backup will fail because the Backup Exec sequence is broken by the outside non-agent SQL backup and will not be reset until another full backup is run by the Backup Exec SQL agent.  An interruption like this will prevent a point in time restore where the point in time selected is later than the last successful incremental backup.

Where the SQL agent backups of Backup Exec are relied upon to enable point in time restores of SQL databases, backups should only be performed with the Backup Exec SQL agent.  No outside or non-SQL agent SQL backups should be performed of those databases.