Douglas: Thanks for the reply. Now does your batch file handle errors from analyze? I'm talking about the errors that make analyze abort. -Jordan

I'm interested in automating VSS maintenance including ANALYZE. I am trying to maintain a sizeable database which has gotten out of hand with respect to corruption, so I need the script to be able to handle errors as they occur. Can anyone recomend an approach to this? What tools/technology would you recomend I start with? Would this be best handled by a batch file or something more advanced? Let me know if I need to furnish you with more information... Thanks very much for any suggestions, -Jordan Atlas

I'm interested in automating VSS maintenance including ANALYZE. I am trying to maintain a sizeable database which has gotten out of hand with respect to corruption, so I need the script to be able to handle errors as they occur. Can anyone recomend an approach to this? What tools/technology would you recomend I start with? Let me know if I need to furnish you with more information... Thanks, Jordan Atlas