Emerald DB disk-dump in SQL

Josh Hillman ( (no email) )
Mon, 26 Jan 1998 17:40:51 -0500

I just realized that Emerald_diskdump.dat (SQL 6.5) is 376MB and is a bit
large. I tried to run a manual diskdump, initializing the device, but an
error popped up saying that the above file expires on 1/27/98 and cannot be
overwritten.

How can I safely overwrite or shrink this diskdump file down to a
reasonable size? The DB itself is allocated 50MB of which, I think
30something is being used, and the transaction logs have their own device
(25MB).

The db goes through a diskdump every night at 3am, and there's data going
as far back as 1996 in the restore area (relating Emerald_diskdump). This
file has been replaced several times in the past, but I don't ever recall
coming across an expiration date, so I'm assuming I changed something in
the automated diskdump that deals with expirations. When looking at
Emerald_diskdump [Info], there's only the past 7 days info in there. I
have no idea why there's such a huge list of info under the Restore tab for
this diskdump (options to restore from diskdumps for nearly every day in
the past year and a half).

Thanks for any info...

Josh Hillman
hillman@talstar.com