lordrahl94 Posted April 29, 2010 Report Share Posted April 29, 2010 I keep having intermittent issues with the transaction log backups. I'm running retrospect 7.7. Here is the error I'm getting. "Trouble reading files, error -3841 ( There is no current database backup. This log backup cannot be used to roll forward a preceding database backup.)" I am running a full database backup every morning at 1am that works without error. I have the transaction log backup running every two hours starting at 2am. I am able to get the backups running properly every time it stops working, but within a few days I'm getting the same error again. There does not seem to be any pattern to when it stops working. Sometimes it will work fine most of the week, sometimes less than a day. Please help me. This has been going on for over a month now. Thank you. Quote Link to comment Share on other sites More sharing options...
Mayoff Posted April 30, 2010 Report Share Posted April 30, 2010 You can not mix the built in SQL backup tools with a Retrospect backup operation, unless you only have Retrospect performing a full backup operation. You need to use one backup tool or another, but not both. Quote Link to comment Share on other sites More sharing options...
lordrahl94 Posted April 30, 2010 Author Report Share Posted April 30, 2010 I am only running retrospect. I have one script for a full database backup, and a second that runs the transaction logs. I have nothing other than retrospect running backups. Quote Link to comment Share on other sites More sharing options...
Mayoff Posted April 30, 2010 Report Share Posted April 30, 2010 Is the full backup completing successfully? The error may be coming from SQL. It sounds like it doesn't believe a valid full backup exists. Are you sure SQL does not have any automatic log backups running? Quote Link to comment Share on other sites More sharing options...
lordrahl94 Posted April 30, 2010 Author Report Share Posted April 30, 2010 The full backup is completing perfectly. I'll check to see if the Sql server has any of it's own backups running when I get a chance, but it shouldn't. Quote Link to comment Share on other sites More sharing options...
Mayoff Posted April 30, 2010 Report Share Posted April 30, 2010 Also check the enterprise management studio for any SQL errors when the backup fails. Quote Link to comment Share on other sites More sharing options...
lordrahl94 Posted May 4, 2010 Author Report Share Posted May 4, 2010 After searching through the sql server configuration and error logs, I finally determined the problem. The sql server's daily maintenance plan included rebuilding and shrinking the database at 1am. I assume that the master backup would run just before this, then the transaction log backup would detect that the master backup was different from the current state of the database. I changed the backup schedule and it has been working fine for the last few days. Thank you very much for all your help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.