JimS-Indy (5/9/2013)
...Even though CPAS could not back up, the error file does seem to show problems with indexes. How do I rebuild all the indexes?
What error shows problems with the indexes?
If you mean
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.
that would be the same cause as the backups failing, specifically that the DB was in single user mode and there was already an open connection to the database, hence the rebuild failed because it could not connect to the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability