September 1, 2004 at 7:47 pm
Hi,
I've got a maintenance plan that backsup my databases and trn logs and is then supposed to delete bak files older than one day. It works fine except that the bak files are not deleted though.
The Maintenance Plan History shows the BACKUP TRANSACTION LOG part of the plan completes successfully. But the NT's event viewer Application Log shows a CAT 3 Event Id of 208 indicating that the backup didn't complete
This happens with 2 of my servers. Can any one help?
Details of my setup are:
SQL Server 2000
Recovery Mode = Full
Backup trn log as part of maint plan
Using default backup directory
September 1, 2004 at 8:19 pm
Hi,
I found the answer in another thread.
I should have looked more carefully first.
Martin
September 2, 2004 at 8:05 am
Always try to help others out when you find an answer. Either post the answer or post the link to the answer.
Thanks
-SQLBill
September 2, 2004 at 5:38 pm
This problem and the solution is discussed in:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=120549
Buffalor posted the solution below:
"Like Jordanac said above, it will fail on all databases with the SIMPLE recovery model, it will also fail if there has been an unlogged event in any database, ie Bulk Loads, Table Truncations.
If you have selected "All databases" use the "Backup These Databases" option, for t-logs do not choose Master, msde or tempdb. If all else fails go down the list of databases in the log and check against the databases that should be getting backed up and make sure none on the list are "SIMPLE".
Clear as mud?"
thanks Martin
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply