Capture.png shows the failed Backup plan.

DBCC Checkdb, etc fails "Incorrect Syntax near " my database name (I substituted the name...CPASD)

"Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon."

I'm working on the rest.

Here's the log file from the failed package:

Microsoft (R) SQL Server Execute Package Utility

Version 11.0.2100.60 for 32-bit

Copyright (C) Microsoft Corporation. All rights reserved.

Started: 2:48:16 PM

Error: 2013-05-09 14:48:30.59

Code: 0xC002F210

Source: Back Up Database (Transaction Log) Execute SQL Task

Description: Executing the query "BACKUP LOG [CPAS] TO DISK = N'D:\Data\MSSQL.1\MSS..." failed with the following error: "Database 'CPAS' is already open and can only have one user at a time.

BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

End Error

Error: 2013-05-09 14:50:31.92

Code: 0xC002F210

Source: Back Up Database (Full) Execute SQL Task

Description: Executing the query "BACKUP DATABASE [CPAS] TO DISK = N'D:\Data\MSSQL...." failed with the following error: "Database 'CPAS' is already open and can only have one user at a time.

BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

End Error

Error: 2013-05-09 14:50:40.63

Code: 0xC0024104

Source: Reorganize Index

Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter.

End Error

Error: 2013-05-09 14:50:53.03

Code: 0xC0024104

Source: Update Statistics

Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter.

End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started: 2:48:16 PM

Finished: 2:50:53 PM

Elapsed: 156.157 seconds

OK, I'm an idiot. I'll reset it to multi-user and try again. Sorry