Re: how to make database 1GB to 700MB ...

From: Peter Yeoh (nospam_at_nospam.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 16:15:58 +0800

Usual step is to create the backup file (~ 1 Gig), then compress it.
Fastest compressor would be lzop, but at a lower compression rate (~ 40%).
Winzip and Winrar would be good choices if you need better compression
ratio. You would then need > 1 Gig of space to work with the backup file
and also the compressed file. Likewise, when you want to restore the
database, you need enough space to store the compressed file, and the backup
file of 1 Gig.

Alternatively, you could use utilities like MiniSQLBackup, SQLLiteSpeed or
SQLZip. What these utilies do is compress the backup file on the fly, so
that you only need enough space to store the compressed file, and you need
less time do create the backup compared to manually compressing the file.
Disadvantage is that these tools are not free, and you need to use the tool
to restore the backup.

Also, as Paul mentioned, you could try shrinking the database before backing
it up, but doing that has its disadvantages too if your database will
eventually grows to that size again e.g. defragmentation, performance hit
when data files grow.

Alternatively, you could take the 1 Gig file, whether you detach the
database or create a backup, and use file splitting utilies to split the
file into 2 parts. You can download a free file splitting utility from my
site.

Peter Yeoh
http://www.yohz.com
Need smaller backups? Try MiniSQLBackup

"chobo sql user" <anonymous@discussions.microsoft.com> wrote in message
news:70468D63-8083-444C-B86D-BFE51E80222C@microsoft.com...
> hi.
> my database is much bic 1GB... so how to make 700MB.
> because cd is 700MB.. I can't put my database to cd..
> Can you help me?? Do you Know Reduce Database..

Relevant Pages

  • Re: Compressing Files
    ... >From Acc97 you can set an option to compress the database on close. ... Access 2003 offers a file option to backup a database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: FTPing a folder across to remote webspace
    ... > lot of repeated test it will compress a lot. ... > gzip only processes single files, so yes you should tar first. ... > In your message you mentioned databases, but not which sort of database. ... MySQL backup. ...
    (uk.comp.os.linux)
  • Re: Free Space Monster (episode 2)
    ... Kicking a Dead Horse by Wiping a Partition with Hex Zeroes ... Did you ever try to compress a backup file, ... compress it using the regular "Create Archive" in OSX's File menu. ... is currently using the sectors or not. ...
    (comp.sys.mac.apps)
  • Re: Moving everything to a larger drive
    ... use a password and compress ... Well unless you live in a fire and theft proof house you would be ... Free, offline backup. ...
    (comp.sys.mac.system)
  • Re: Regarding tar and split
    ... programs like afio that compress files individually to protect against ... (which typically don't compress well). ... I've written backup script that keeps track of file ... Etch), you can put some drives in it, set it up for raid1, and use it as ...
    (Debian-User)
Loading