1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem .zip back files

Discussion in 'Software' started by westernkings, Jul 1, 2010.

  1. westernkings

    westernkings Gigabyte Poster

    1,432
    60
    107
    Hey gents,

    I have a maintainance plan for SQL server to create a new backup every hour, I need to zip them up hourly and then FTP them to another site.

    Does anyone have any ideas of software? or instructions to get it done?

    cheers guys.
     
    Certifications: MCITP:VA, MCITP:EA, MCDST, MCTS, MCITP:EST7, MCITP:SA, PRINCE2, ITILv3
  2. westernkings

    westernkings Gigabyte Poster

    1,432
    60
    107
    Or even just a batch file that will zip up files modified in the last 2 hours.
     
    Certifications: MCITP:VA, MCITP:EA, MCDST, MCTS, MCITP:EST7, MCITP:SA, PRINCE2, ITILv3
  3. SimonD

    SimonD Terabyte Poster Moderator

    3,463
    397
    199
    I would check to see how much compression you're going to get for those BAK files because my understanding was that they were already compressed, you may just want to set up a RichCopy or Robocopy job to move them.
     
    Certifications: CNA | CNE | CCNA | MCP | MCP+I | MCSE NT4 | MCSA 2003 | Security+ | MCSA:S 2003 | MCSE:S 2003 | MCTS:SCCM 2007 | MCTS:Win 7 | MCITP:EDA7 | MCITP:SA | MCITP:EA | MCTS:Hyper-V | VCP 4 | ITIL v3 Foundation | VCP 5 DCV | VCP 5 Cloud | VCP6 NV | VCP6 DCV | VCAP 5.5 DCA
    WIP: VCP6-CMA, VCAP-DCD and Linux + (and possibly VCIX-NV).
  4. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    Cheap and cheerful SqlBackupAndFTP, the pro version will do AES Zip files encryption and FTPS if you need an extra layer
     
    Last edited: Jul 1, 2010
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  5. westernkings

    westernkings Gigabyte Poster

    1,432
    60
    107
    They go down from 3GB to about 400MB after being zipped.

    That program is all right, but it took half an hour just to back up and zip 6MB of Database, SQL maintainance plan backs up every data base in about 10 minutes.

    So I need alternatives. Can 7zip command line be set up to zip up only newly created files or files created within the last hour?
     
    Certifications: MCITP:VA, MCITP:EA, MCDST, MCTS, MCITP:EST7, MCITP:SA, PRINCE2, ITILv3
  6. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    Thats odd, our DB backups are much bigger than that (4 in total range from 21-39 MB) and are all backed up, zipped, and move the network share ever hour with that program, notice the timestamp are still on the hour thus <1m
     

    Attached Files:

    Last edited: Jul 2, 2010
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  7. westernkings

    westernkings Gigabyte Poster

    1,432
    60
    107
    what settings are you using for compression etc? and are you connecting locally or remotely?
     
    Certifications: MCITP:VA, MCITP:EA, MCDST, MCTS, MCITP:EST7, MCITP:SA, PRINCE2, ITILv3
  8. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    Level 5 and it runs local on the MS SQL server and no encryption
     
    Last edited: Jul 2, 2010
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  9. westernkings

    westernkings Gigabyte Poster

    1,432
    60
    107
    Is this safe to use on Live Databases mate?
     
    Certifications: MCITP:VA, MCITP:EA, MCDST, MCTS, MCITP:EST7, MCITP:SA, PRINCE2, ITILv3
  10. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    I'm a couple of version behind the current, I use 3.4.3.35249 and it works perfectly well on our live 30 user system, do you have remote access for out of hours? If so I would suggest making a normal backup of you DB server out of hours via SQL SMS and then run the SqlBackupAndFTP backup and see how you get on, our DB server isn't anything special garbage ram, cpu, and a crappy p400 with 6 15k SAS drives and I've never had a problem with this program.


    Just to prove it I will show you a video of me doing on our live setup and PM you the link :D
     
    Last edited: Jul 2, 2010
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  11. westernkings

    westernkings Gigabyte Poster

    1,432
    60
    107
    Ok guys,

    still having trouble, the SQLFTP software above only does full backups, which still means I can't FTP them up fast enough.

    I need to be able to back up the SQL databases, and ship them to another server via FTP, in a short a time as possible. If I could get a bit of software like the one above that does incremental that would be great. Other than that, I am out of ideas. I've heard log shipping but don't understand or even know what it is, how it works, or what it does.
     
    Certifications: MCITP:VA, MCITP:EA, MCDST, MCTS, MCITP:EST7, MCITP:SA, PRINCE2, ITILv3
  12. LukeP

    LukeP Gigabyte Poster

    1,194
    41
    90
    Log shipping is when the logs from one server are shipped to other server and replayed there so the databases are the same. Means you would need a second server at the remote location to hold the copy of the database.
     
    WIP: Uhmm... not sure
  13. westernkings

    westernkings Gigabyte Poster

    1,432
    60
    107
    We do have another SQL server set up, an exact copy.
     
    Certifications: MCITP:VA, MCITP:EA, MCDST, MCTS, MCITP:EST7, MCITP:SA, PRINCE2, ITILv3
  14. LukeP

    LukeP Gigabyte Poster

    1,194
    41
    90
    Which version of SQL Server do you use?
     
    WIP: Uhmm... not sure
  15. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    You could contact them and see if that feature can be added, can't see it being that hard.
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)

Share This Page

Loading...