Monday, July 30, 2007

Corrupt Arcserve database

Have an installation with Arcserve 11.1 where when you attempt to access either the device screen or the database screen the console hangs and has to be terminated by task manager. The tell tale sign that there is a problem with the Arcserve database is the fact that the Arcserve backup job runs but the details are not recorded in the database. So bottom line corrupt database.
 
Normally, this is pretyy easy to fix, you simply go to the Arcserve server admin and reinitialize all the Arcserve databases. This basically empties them ready for new content. If you need the Arcserve database back then you can simply restore from a tape or restore the Arcserve database itself.
 
Problem is when we went to initialize the database we got the same hang. There are good arcticle from CA about Arcserve databases here. Down the bottom it mentions about deleting the rdm files. We did this and still had the same problem. Next it mentions editing the velocis.ini file which we did and hey presto we could go in and reinitialize all the Arcserve databases. Also our console manager no longer hung when we acccessed the database screen.
 
Interesting this site also from CA says that you should be running maintenance on the Arcserve databases weekly. First time we have heard of that! It is a good idea when you have very Arcserve databases but generally it is easier just to reinitialize them and start fresh. has worked everytime for us.