SMS SQL Monitor failed to execute database maintenance task "%1".%12 Possible cause: A SQL Server problem prevented this ...

System Center Configuration Manager 2007

%11SMS SQL Monitor failed to execute database maintenance task "%1".%12

Possible cause: A SQL Server problem prevented this task from running.
Solution: 
1. Review the immediately preceding status messages from this component about SQL Server errors.
2. Verify that this computer can reach the SQL Server computer.
3. Verify that SQL Server services are running.
4. Verify that SMS can access the SMS site database.
5. Verify that the SMS site database, transaction log, and tempdb are not full.
6. Verify that there are at least 50 SQL Server user connections, plus 5 for each SMS Administrator console.

If the problem persists, check the SQL Server error logs.

Most database maintenance tasks are designed to optimize database performance. If a task fails once, the effect on the system will be small and you can ignore the failure. But if a task fails repeatedly you should investigate and fix the problem.%0

SMS SQL Backup service on the SQL server %1 failed to backup the SMS database %2. The error reported by the service is %3. ... SMS SQL Monitor could not start the SMS Backup service on server %1.%12 Possible cause: You changed the service setting for ... SMS SQL Monitor failed to copy file smsxp.dll from the \SMS\bin\i386 directory (or \SMS\bin\alpha if this is an Alpha computer) ... SMS SQL Monitor failed to execute database maintenance SQL command "%1".%12 Possible cause: The SQL command contains syntax ... SMS SQL Monitor failed to execute database maintenance task "%1".%12 Possible cause: A SQL Server problem prevented this ... SMS SQL Monitor failed to install trigger "%1" in the SMS site database.%12 Possible cause: Either table "%2" or column "%3" ... SMS SQL Monitor is executing database maintenance SQL command/task "%1". You can configure the execution schedule for this ... SMS SQL Monitor is installing trigger "%1" for table "%2" and actions "%3" in the SMS site database. Server components such ... SMS SQL Monitor is removing trigger "%1" from the SMS site database. Server components such as SMS Hierarchy Manager, SMS ...