Jeff,
If you have huge numbers of files/versions you get a huge database.
Are you running expire inventory every day.
Can you reduce the number of files/versions.
Negotiate with the users make sure you are only backing up what is really
needed.
Query all your clients to make sure that they are all still valid ie. you have
not got old clients which no longer physically exist and whose filespaces can be
deleted.
John





Jeff Justus <justusj AT SQUARED DOT COM> on 14/04/2000 13:12:38

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  DB to big



My ADSM database is growing at a fairly alarming rate, the database is almost 17
gig now and I would like very much to shrink or compress it... I had several
RS6000s that (thanks to SQL Backtrack) got up to around 1 TB before they were
caught. I have expired the tapes and audited the library but the DB is still
huge... Please help a Newbie out and tell me how to shrink the DB.


Jeff Justus






**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************