SSIS Maintenance Package fails every other night????

Question

I have a maintenance package that backs up my databases and refreshes indexes.  It runs every night.  Every OTHER night I get an error in the event log of the server hosting SQL Server.  (2008R2)

The thing is, it doesn't fail.  The backups are there every morning.  I believe the indexes are being rebuilt.  I ran the app seven or eight times manually without any failures.  I'm confused.

Any idea what might be going on?

Answer 1

And what is the error?

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Answer 2

Separate out the maintenance tasks into its component parts to narrow down the problem if you cannot tell the issue from the error message.  Work out if the issue only applies to a specific database or action.

If its happening every other time, it would imply that you have some find of precedence issue (i.e. something is created after it is referenced), but it is hard to tell without more detail