I believe this topic was discussed before and that there could be a
problem deleting the files if there's still data on them.  If I'm
remembering correctly, the data in the database can get spread
throughout and sometimes the only recourse is to restore the database or
reload it from a dump.  Does anyone else remember this?

Tina Hilton
Thomson Consumer Electronics

        ----------
        From:  Randall Eggert[SMTP:RANDYE AT MAPCOINC DOT COM]
        Sent:  Thursday, April 02, 1998 7:05 AM
        To:  ADSM-L AT VM.MARIST DOT EDU
        Subject:  Re: Deleting DB and Log Volumes on NT

        Phil asked about deleting his old DB & LOG files after defining
new ones.

        You must REDUCE the size of both your DB & LOG files by the
amount of space
        that is provided by your original DB & LOG files.

        Your new DB & LOG files are 808MB & 64MB respectively.  Say your
old ones
        were 404 and 32, then REDUCE DB 404 & REDUCE LOG 32.

        When you query your db, Q DB, the Maximum Extension field will
show 404MB.
        Then issue your DELETE command.  A process will start, migrating
all DB
        data from the old file to the new.  When complete, the AVAILABLE
SPACE and
        ASSIGNED CAPACITY will reflect the file sizes for just your new
files.

        (Gee.... I hope this still works for V3, as I  am still on V2)

        Good Luck
        Randall Eggert
        Tulsa