Zip Backups and Copy to Secondary (free)

  • chudman

    SSCrazy

    Points: 2420

    Comments posted to this topic are about the item Zip Backups and Copy to Secondary (free)

  • Manish_

    Ten Centuries

    Points: 1070

    How can i perform the same in SQLSERVER 2008, I got some errors like

    "'FORFILES' is not recognized as an internal or external command,"

    - Manish

  • chudman

    SSCrazy

    Points: 2420

    Manish,

    FORFILES is an OS function that is probably deprecated in Windows 2008. Fortunately, if you get the latest version of gzip, you can simply use the -r switch to recurse through the entire directory and the -k switch to retain the original file untouched. The latest version of gzip makes having to use FORFILES unnecessary. Using FORFILES was lazy of me.

    Jeff Bennett

  • Manish_

    Ten Centuries

    Points: 1070

    Hi Jeff

    Thanks for the information, I will look for these.

    - Manish

  • jdexheimer

    Newbie

    Points: 3

    why gzip and not something like 7zip that has more options for configuration?

  • chudman

    SSCrazy

    Points: 2420

    The existing team of DBA's I was hired to assist were more comfortable with gzip because it had been used in their previous lives as Unix gnomes.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply