sql 2000: Data Maintenance Plan failing on Logs
-
I am running SQL 2000 Svr SP3a on a Win2003 Svr Std system.
When using Enterprise Manager data maintenance plans to secure the database and logs to a local disk, the databases backup OK but the logs fail (only one of the 4 selected database log files is backed up) with the following error in the windows event viewer:
The job failed:The job was invoked by Schedule 5 (schedule 1). the last step to run was step 1 (step 1)
Has anybody encuntered this before?
Any assistance would be appreciated.
-
Check the recovery model of the database that is failing. If it's set to 'simple', then you can't do transaction log backups.
--------------------
Colt 45 - the original point and click interface
-
Check which type of recovery model you're using. If you're using the Simple Recovery model the transaction log backups aren't used in recovery, so the maintenance plan is ignoring this task and reporting an error. The one log that is backed up is probably using the Full or Bulk-Logged recovery model.
Review your maintenance plan. Under the Transaction Log Back Up tab you can choose to turn off the back ups - but this affects all databases in the plan.
-
1) Open Enterprise Mangler, navigate through Management->SQL Server Agent->Jobs and locate your failed job.
2) Right click on the failed job, and select "View Job History ..."
3) In the Job History dialog click the "Show step details" check box in the upper right corner.
4) Click on the failed job step(s) and the specific error should be displayed in the info field at the bottom of the dialog.
Steve G.
-
Many Thanks,
The recovery model was set to simple.. amendeed to Full, now all OK
Regards
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply