Hello M Tuttle (KS),

> In order to trim down the size of the database after deleting record, it is
> necessary to do a backup (With Garbage Collection), followed by a restore of

if you do a restore, then there is no need for the garbae collection

> the database. This is the only way to reduce the size of the database.
> Simply deleting the records will not reduce the size of the database.

> Mike

>>
>> Ive got a database thats about 270 mb in size.
>>
>> I deleted the majority of the data within the tables and commited
>> the transaction
>> but the size of the database remained the same size.
>>
>> Why would this be ?
>>
>> How can I delete the majority of the data within the database and
>> reduce the database file size ?
>>
>> I have about 14 tables with 1 trigger and 1 generator per table and
>> about 8 of the tables have approx 3 indexes per table.
>>
>> tia
>> Andrew

--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...