Solved

Arcserve 2000 database size.

Posted on 2004-09-21
4
6,062 Views
Last Modified: 2008-07-08
Hi there,

We are running Arcserve 2000 backup solution.

The problem is that the databases have grown to a size that we are concered about disk space. We have looked in the database folder within program files and have found 3 files called:

ASTPSDAT.000
ASTPSDAT.001
ASTPSDAT.002

There are other many smaller files within the folder that increase in file size as follows: 1k, 2k, 3k, 4k......32k, 64k etc.

The three files above come to 2.7 gigs and we are not sure if these are needed. If they are not needed can they just be deleted are is there something we need to do within Arcserve admin.

Thanks for your help.
0
Comment
Question by:clivecrawdevil
4 Comments
 
LVL 15

Expert Comment

by:Yan_west
ID: 12112477
You have to run maintenance utility on your database to defrag and maintain it..

check this link:

http://esupport.ca.com/index.html?/public/brightstoreb/infodocs/bs1407.asp
0
 
LVL 22

Accepted Solution

by:
dovidmichel earned 125 total points
ID: 12118755
The common question is can the database be moved to a different location? no
Those files are for the astpsdat database which holds the records of all the files and directories backed up.
They can not be safely deleted.
For a quick fix to free up space go to the ARCserve Server Admin, select the Database tab and then under Operation select initialize and then initilize just the astpsdat database.

After that you will not see the files and directories backed up for any old backups, but if a restore is needed then the session can be merged back in.

Running defrag is fine as long as there is empty space in the database if there is no then it will not get you any free space. Further more it creates output files which have to be manually deleted afterwards to regain the free space.

You might want to think about reducing the number of days for the Database Prune job. It is set in the ARCserve Server Admin, Configuration, Database tab. Reducing the number of days will reduce the amount of data stored in the database.

After that is done then you can run dbdfrag but I suggest keybuild. It will repair corruption, remove empty space from the database, and not leave any output files. There is a doc in the home directory that explains the utilities, in 2000 I think it was called vldbutil. The above mentioned doc is good and I think there are a few more there that might help.
0
 

Author Comment

by:clivecrawdevil
ID: 12125310
Thanks for your help on this.
0
 

Expert Comment

by:saadat_saeed
ID: 12269791
Yes I too had this problem with Arcserve databases growing huge.... you can set an option in the arcserve admin to delete database records after a certain number of days. I use 45 days!

However, I have switched to SQL server to host my arcserve database records instead of arcserve's default.... i find an overall improvement in performance!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Sometimes the best way to deal with an infected computer is to boot from external media and run your tools from there.  The reason you may wish to do this really depends on the infection.  Some malware is so recalcitrant that no matter what you do i…
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now