February 12, 2002 at 8:46 am
I have a maintenance plan that runs a differential back up every hour and truncates the transaction log every 20 minutes. The job ran smoothly for three days, but the past couple of days it has failed. What could be the cause of this issue? I set up similar plans on another server for two different databases and have not run into this problem.
February 12, 2002 at 9:07 am
This is an add on to the previous post. The error is SQL State 4200 which turns out to be either a syntax violation or an access violation. We've ruled out syntax, but are wondering what would cause the access violation.
February 12, 2002 at 11:01 am
Is that all you're getting in the history? Plenty of disk space?
Andy
February 12, 2002 at 11:26 am
That's it. No disk space errors.
February 12, 2002 at 11:43 am
Not much to work with. Can you do a log backup manually, either through EM or QA? Might want to stop/start the agent, I find that fixes a lot of weird problems. Have you run DBCC checkdb on the db in question just to be sure?
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply