July 14, 2009 at 12:13 pm
I get this error when I ran my Transaction jobs, any idea why?
Executing the query "BACKUP LOG [CSI_Int] TO DISK = N'F:\\TransactionJobs\\CSI_Int\\CSI_Int_backup_200907141200.trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, NAME = N'CSI_Int_backup_20090714120038', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "BACKUP LOG cannot be performed because there is no current database backup.
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
July 14, 2009 at 12:25 pm
Well, the error message is pretty self-explanatory. You have to have a Full database backup before you can run log backups. So either your backup chain has been broken, or you have never taken a full backup.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply