I've created a maintenance plan and getting the following error message in the event log. This has been working for a while problem happend a week a ago, no changes to the system. Novice SQL user, any help on this appreciated.
Event ID 208. SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'RSS Pro2000 DBMP'' (0xFE3D7C9C154F9E48A4AA953C88D9F97E) - Status: Failed - Invoked on: 2007-03-19 13:28:00 - Message: The job failed. The Job was invoked by Schedule 13 (Schedule 1). The last step to run was step 1 (Step 1).
Are there any changes to the recovery model during this time of execution?
Also check the password or any information pertaining to SQLAgent account used here.
http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp fyi.
|||No changes made. SQLAgent using 'Local System' a/c|||Try to execute the job as manually with your account credential.
Do you have any other databases scheduled in this database?
if so are they getting same error?
|||The Db's are being backed up (there's 4 in total). It's only the transaction log that are not running.I've changed the a/c to 'administrator' and ran another transaction log and getting the same message.|||Have you applied the service pack or any changes to the server recentlY?
No comments:
Post a Comment