Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ArcserveIT 6.6 backup data not merging to database 1

Status
Not open for further replies.

JoA

Technical User
Feb 7, 2001
3
GB
Hello!

I am currently backing up onto 2 tapes (which I know is not ideal!). However when I come to restore, the data is not stored within the database. I first have to merge the tapes which takes the best part of a day to see whether the information is there.
This does not happen on another server which only uses 1 tape.

Any advice would be appreciated as restores are now becoming labourious..

Thanks. :)
 
JoA, I posted this elsewhere, hope it helps...
----
Since there seem to be lots of database and performance related questions out there right now, I'm making this post to try to help out as many of you as I can.

I use ArcServeIT Advanced Edition 6.61 (Build834,SP2a) on Windows NT 4.0 (SP5). All information in this post is accurate for this configuration, but it will change for other OS's and ArcServe versions.

First of all I suggest that ALL ArcServeIT Admins take a look at Document # 16112 on the CA website.


This document is all about the RAIMA database and how to maintain it. RAIMA is the database type that ArcServeIT (at least 6.61) uses by default. You can specify Microsoft SQL for your database type during the initial install of ArcServe if you want, in which case all database maintaining must be done by a SQL Administrator.

There are basically four things you should be doing regularly with your database. These will help with a multitude of problems including performance since the database is used for all aspects of ArcServe.

They are Prune, Check, Repair, and Pack.

Prune
What: Removes old entries from the RAIMA database.
How to: From ArcServeIT Server Admin, click the Config button (wrenck and sprocket), select Database Engine tab and check the 'Enable Database Pruning' box. Schedule it to run once a day. It can run during your production day. Currently, I prune all entries after 30 days. You do not lose your data if you have older tapes, you'll just have to do a Merge of those old tapes if you need to restore from them later.
Problem: Leaves blank spots in the database causing it to eat disk space.

Check
What: Inspects the RAIMA database for errors
How to: Run the DBMGR.EXE program from the ARCSERVEIT directory on the ArcServeIT server. Sorry, CA didn't include this one in the StartMenu icons. I suggest you put a shortcut there. Select the 'Check' tab and Start a check on All Databases.
Problem: None

Repair
What: Repairs the database errors that Check finds.
How to: Run the DBMGR.EXE program again (should have a shortcut by now...HINT). Click the 'Repair' tab and run it on all databases.
Problem: Repairs can take a while, esp. the astpsdat database

Pack
What: Compacts the RAIMA database to re-claim disk space lost due to Pruning
How to: Run the DBMGR.EXE program from the icon you created earlier in your Start Menu. Click the 'Pack' tab and do a Full Pack on All Databases. After doing this once, and IF you are diligent about maintaining the databases, you can start using the Quick Pack.
Problem: This should only be done after a Repair has been done and this too can take a while.

Again, I can not stress this enough...I suggest that ALL ArcServeIT Admins take a look at Document # 16112 on the CA website.

Monkeylizard
-Isaiah 35-
 
Thanks for this tip - it works with my NT servers but I need the same utility for Netware.

Does anyone know if Netware has the same detailed utility? I can only find a basic utility which allows for Pruning and purging but no Pack option. Does Netware do this automatically ?

Any help appreciated.

Thanks :)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top