Solved

Arcserve 2000 database size.

Posted on 2004-09-21
4
6,076 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Solid State Drive Performance Tips: Solid state storage technology is now a standard.  After testing and using several different brands and revisions of SSD's over the years I have put together a collection of tips,tools and suggestions that I ha…
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…

724 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