Results 1 to 6 of 6

Thread: ZIP BAK File

  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    ZIP BAK File

    Any one zip a backup up?

    Doing a 1GB now...how much compression do you think I'll get with PKZIP?

    Let you know, and thanks for all the help with the network nightmare...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,634
    Ratio will not be very impressive, but you may get it down to 600 to 800M. But I'd go for SQLLiteSpeed if you're after compression. Talking about impressive results!!!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    14,914
    PkZip can only handle files up to either 2 Gb or 4 Gb, depending on the version. WinZip 9.0 can handle just about anything you want to give it. Both compress the backup to less than half the original size, and usually much less than that.

    -PatP

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    WINZIP 8.0 Got me from 1GB to 200MB...guess the TLogs must have a lot of empty space.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    That's pretty normal I just zipped a 1gb file to 198mb earlier today using WinZip. The transaction logs were pretty much non-existent.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  6. #6
    Join Date
    Dec 2002
    Posts
    1,245
    We transferred a database this way from another agency. They were able to pack a 2.5 GB BAK file into 510MB.

    Regards,

    hmscott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •