Backups Hang at 99 percent completion

[jeff5144]

We are consistently getting backups hanging at 99% each time we create a backup. We are on Windows 2000 Server (SP2), ArcServe 2000, Exchange Agent. The tape drive is a Sony SDT-10000. The total backup is approx 14 gigs. I have checked the event log in Arcserver and there are no error messages. Any ideas?

 

[ARCserveGuru]

At 99% the backup is writing to the database, if there is a problem there, then the backup will hang. Check the arcserve directory using explorer and browse to temp, are there any cat files? (files with the .CAT extension). If there are then your not getting into the database at all, and as such I doubt a restore will work unless you restore by backup media. Anyhow, try initialising the database by going to arcserve server admin, clicking on the database tab and going to the drop down menu "operation", then select initialise, and initialise the astpsdat database, or all database (all databases will screw up your media pools, as in delete them, but if you have no pools then I recommend all instead of just one).

Hope this helps, if this doesn't work there are are things to do such as getting the database engine to "log on as" the arcserve system account. etc.... Also, after you initialise, run the utility 'mergecat.exe' which is found in the arcserve directory, this will merge the .CAT files from your /temp directory into the database. If this was an upgrade also? Then check to make sure in the environmental variables that CATPATH is pointing to the correct location of the ARCserve Database and check that the RNNAME variable is the correct name of the current server.

Man, try saying all that in one breath

good luck

guru

 

[jeff5144]

Thanks, I tried these suggestions, I actually didnt find any cat files in the temp directory. I also went into server manager to initialize the datasebase with the "all" option selected and got a few error messages. I am attempting now to just back up the brick level. However with the new backup job I submitted, I got the following error code:

Error 4101

4101 Unable to login to database engine. (DATABASE=database_engine_name, EC=
db_error_code)

Module:
Database API

Cause/Solution:
Check the error code.

 

[ARCserveGuru]

Try to get the database engine in the services to log on under a local administrator account if you have already tried using the arcserve system account. Also, there should be no files .TMP or .CAT in the arcserve temp directory. If your getting unable to login to the database then quite frankly there has to be something there!!! There must be or else theory doesn't mix with practical. Also, have you deleted the wascally RNNAME variable? if not, delete it and *ahem* reboot when you got the time to. I thas to be one of these.

guru

 

[jeff5144]

Hi there,

Thanks for your information, I ended up shutting down the Norton antivirus for exchange software while the backup goes through. I need to create a batch file that shuts down this service during the backup. Do you know where the pre/post commands run from? Is it the winnt\system32 directory? Also, I am close to getting flawless backups, except for the: (Is this because the service account under the database is not valid?)

Error 8602

8602 Failed to read from database. (DBNAME=object name, EC=error message/code)

Module:
Backup Agent

Explanation:
The Backup Agent error (EC=error message/code) occurs while Backup Agent reads data stream in a backup object(DBNAME=object name) from Database server to ARCserve.
Check the Backup Agent Log file for details.

 

[wjense]

There's a log file on your target server, that's where the backup agent log is. Check that. It could also be that the username you have for your agent id doesn't have sufficient rights on the Arcserve server...it needs probably at least backup operator rights locally, if not admin to write it's data to the remote database.