SQL Server database maintenance plan log job failure Solution

SQL Server database maintenance plan log job failure Solution

 

Event Type: Warning
Event Source: SQLServerAgent
Event Type: Job Engine
Event ID: 208
Date: 2005-12-22
Event: 2:30:01
User: N/
COMPUTER: MC
Description:
SQL Server scheduled job 'db maintenance plan "pubs maintenance" transaction log backup job (multi-server ). '(0x31a2a332036d604a98e32150d75b5d05)-Status: Failed-invoked on: 02:30:00-message: Job failed. Scheduling 3 (1st scheduling) wakes up and calls the job. The last step is Step 1 (step 2 )..

 

If the above error is found in the event viewer, view the "Database Maintenance Plan" attribute, as shown in.

Click "view history" to display the following information.

 

Click "attribute" on the database and view "fault recovery model". It is found to be "simple". The preceding error occurs only when logs cannot be backed up in the "simple" model, change to "large-capacity log record" or "complete.

Of course, other situations may also trigger similar warnings. For example, the database has been deleted, but the database is still used in the maintenance plan.