Database getting too large

[hccmhb]

I am running ArcServe IT 6.6 on a Netware 4.11 server. However the astpsdat.db is now 1/5 GB, and it is on our SYS drive (down to 80 MB). I think I have 2 options.

1) Move the database to the data volume, uninstall and reinstall ArcServe IT on the data volume, then remerge the database.

2) Delete the database files (or move them), and start a new database. If this is the case, I would then have to merge a tape anytime someone wanted a file restored. Correct?

Any other ideas?

 

[cq]

Try packing the database. asdb p=astpsdat.db is the command. See

http://support.cai.com/techbases/as61/NAS60925.html.

N.B You need 2.5x the file size as free space so you'll need to move it to a different volume.

Also check that you are not keeping records for longer than necessary - reduce your # of days before purge if necessary.

The alternative, as you correctly state, is to replace the database. Stop Arcserve, delete the Database dir files, copy the files from EmptyDB and re-start Arcserve.

N.B. If you decide to re-install Arcserve, if possible put it on a volume other than SYS. If SYS fills up completely you have a problem.

Pete

 

[hccmhb]

Thanks Pete, that is what I figured I had to do. I inherited this system, and I am finding a couple "screwy" things.

We rarely have to restore for people, so I am thinking we are going to restart the database, and turn on auto pruning.

Ron

 

[cq]

That's always a good way of clearing it down. In my experience merging tapes can take a couple of hours; if I start with a clean database I usually merge in a recent set of tapes just in case I get an urgent restore request.

Pete

 

[ShanLee]

Does anyone know what a recommended maximum dtatbase size would be. I am on a client site at the moment and noticed they have databases between 1.5 and 3.5 GB. Surely this is way too large to be safe, although disk space isn't an issue.

 

[ajtmcse]

Maximum DB size is relative to the customer (# of servers/directories/files) and what version of Arcserve they are running.

Arcserve 9 for Windows "standard" DB can handle over 20GB of DB files. I'm working with a customer who is using SQL (for their BABv9 DB) at the moment and has a 25.2GB database. ASTPDAT table on their server has over 126 million entries.

-Tony