Thank you, that's what I thought, but my boss keeps telling me other people are doing it. And mirroring is not an option for us because you can't mirror MSDB...

I don't have the model # but it's the newer version from Xiotech - 7.5T

Thanks for the suggestions, I have most of scipts written. I was hoping for a tool that would drop constraints, move data and rebuild constraints. Sounds like a niche market...

I wasn't failing on the same table each time, but the really strange part is that I deleted and recreated the schedule, not the job or the package, and now...

I had the same issue, to get around it I am using configuration file stored in the file system that I had to manually open up and add the password...

Thank you, this confirms what I believed to be true.

I have already done all of our stand alone servers including one that is AWE enabled, the hotfix after SP4 install works fine for AWE. Unfortunately, the only cluster in...