08-28-2012 11:01 AM
Hello,
I have a job setup to backup all databases in an intance of mssql 2008. The full backup will complete sucessfuly, as wil the next incremental job. But after that the next few incremental jobs will fail with the following error:
V-79-57344-867 - The last Full backup of database XXXXXXX was not made by this application. Run a new Full backup, then run this job again.
Why is does it keep saying this? There is a full backup being done on the database, i've even setup a second job one time job to backup that database with a full backup. We have ful backup's scheduled twice times a week of this database, and next day the incremental job will complete, but then it will fail.
Can someone please advise.
08-28-2012 12:39 PM
Hi Scott,
Check the link below:
http://www.symantec.com/connect/forums/sql-database-backups-0#comment-6990021
Thanks!
08-28-2012 06:04 PM
Use the procedure in this document to determine which application did the last backup of the database.
If the SQL instance is in a VM, then see this document
SQL Log Backup job fails if run after an AVVI or Hyper-V backup of the SQL Virtual machine