VSS maintenance
-
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
-
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
VSS sucks, and I don't know nothing better...:(( It's not client/server and VB integration is horrible! If your "clients" do not run in an stable network (forget VPN!), and stable OS (Win2k, for eg.), data corruption will occur. My experience with ANALYZE is disastrous... X| I'm triying CVS and SourceOffSite right now, but I can't emmit an opinion because it's too early.
-
VSS sucks, and I don't know nothing better...:(( It's not client/server and VB integration is horrible! If your "clients" do not run in an stable network (forget VPN!), and stable OS (Win2k, for eg.), data corruption will occur. My experience with ANALYZE is disastrous... X| I'm triying CVS and SourceOffSite right now, but I can't emmit an opinion because it's too early.
This might be news: But you can get corruption in a stable network with Win2000 clients throughout. It just happens sometimes. What has seemed to help sometimes is to just get everyone out of the VSS pool. When we have the most problems are when lots of people have things checked out keep VSS/VCC with VSS up all the time (i.e. during Crunch). Sometimes just having everyone exit will let VSS fix itself, and occasionally the Admin gets us all out and does maintenance on a Saturday.