Yesterday, I removed mirroring for this database and set it up again. That solved the problem.

Unfortunately, it doesn't tell me what caused the problem so that I can...

At one point I thought this problem might be permission related because the error in the SQL Server log starts out with "Login failed for user..." However this error and...

Any database that is offline doesn't show up in the list of databases available for backups.

When I switch a maintenance plan from all database to those I specify...

I thank you all for your replies so far. As I have been going through them and getting ideas on what to look at I have been narrowing down the...

Thanks.

It looks like I was looking in the right place for the maintenance plan logs and they don't offer any useful information about the error I am getting.

I have considered scripting the t-sql from the plans and using that code as a temporary fix, however I prefer to keep using the maintenance plans.

Has anyone dealt...

Thank you both for your patience and for explaining things I did not understand nor consider as I thought about this. I begin to see how this becomes more complex...

I guess it would have helped if I had explained better.

The deadlocks I see the most often are with two SPIDS having a page lock on the same index...

Thanks for the quick reply. I suspected that might be the answer but wanted to be sure it wasn't just me missing something, like some undocumented DBCC that didn't come...

I hate when problems are so simple I can't figure them out. I just figured out the problem. I needed to include both columns in the Source Columns...

I think I have found what you are talking about.

I select configuration type as parent package variable and then tell it to put whatever is in that package variable into...

I learned about how tables relate to each other at my current job by talking with people who were here before me and modifying existing SP's to add new features....

Another thought is that if the SP that everyone is running can return a different number of rows depending on what parameters are sent into the SP then the user...

I forgot about that. Yes I am on call too and had to work 40 minutes from home this past Saturday. The thing is officially the time you...

Thanks for all your help!:)