Astpsdat database is too large

[Palagast]

The database of my ARCserver (2000, version 7, build 1086) installation is currently 2,7 GB large. That's too large to my liking, so I want to reduce it. I've set the pruning from 30 days to 14 days old records, but that did not seem to do anything. Even the "Submit database pruning now" option in the Server Admin module doesn't (seem to) do anything. What's the best way to reduce the suze of the database files and if it's the way I described above, what am I doing wrong here?
Thanx in advance.

 

[speshalyst]

Hi,


I'd say.... initialize.......


cheers
speshalyst So it Shall be Written!
So it Shall be Done!!

 

[fritz4000]

Pruning will not remove used space from the database, but will only create white space of what has been removed that should be used first prior to using more. I believe that you can run the keybuild utility to remove the white space.

 

[databasebaba]

Run the database utilites as per the URL.... the function of DBDEFRAG is to prune the database ....

give it a shot ....

It works for me but it takes more time ... Try scheduling it at night...

http://support.ca.com/techbases/as2000/as2k-1521.html

DatabaseBaba...

 

[craigeo]

I have a similar problem. My databases get way too large and I can't keep up with them with the keyrebuild, etc database utilities. I backup approximately 850gb of data per night. (5 dual tape drive network (1gb) attached tape libraries controlled by 1 server). I keep 14 days worth of data, my total database size (the whole directory) is around 10gb. The db utilities take a couple days to finish on that big of databases. When the databases get this large the update database at the end of the backup jobs takes forever. Is Arcserve 2000 SP4. I'm looking at 2 different options... only keeping around 7 days of data or trying out putting the db on a SQL server. Any ideas or suggestions?

 

[Cyklops]

The 7 days option will not solve your problem. Switch to SQL for databases of this size. SQL is a a slower but far more reliable solution for the ARCserve database if it grows above 5/6 GB.

regards