Zip Backups and Copy to Secondary (free)

Question

Post reply

Zip Backups and Copy to Secondary (free)

chudman

SSCrazy

Points: 2453
More actions
June 9, 2009 at 7:53 pm

#210692

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

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

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

Manish_ Ten Centuries Points: 1070 More actions · Answer 1

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: 2453 More actions · Answer 2

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 More actions · Answer 3

Hi Jeff

Thanks for the information, I will look for these.

- Manish

jdexheimer Newbie Points: 3 More actions · Answer 4

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

chudman SSCrazy Points: 2453 More actions · Answer 5

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.