Post reply

Help required Urgent...!!!

  • March 7, 2009 at 11:43 am

    #131988

    Dear All,

    Iam facing one problem with the network traffic issues.

    Issue : Actually we have num of servers at our local area Say Chennai. I would like to move backup files from this chennai server to the production server inorder to restore the backup on US machine.

    Its taking nearly 1.5hrs to copy 1.6GB files to the US server drives. Can i do this copy backup files much faster from Chennai (INDIA) to US server. We are not using any tools.

    Please suggest if thats possible by the existing.

    Thanks,

    CH&HU.

  • March 7, 2009 at 12:40 pm

    #955539

    Compression would be an option for you.

    I am not sure how well backups compress with standard compression tools; but tools like RedGate Backup work nicely to compress it before shipping it off.

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • March 7, 2009 at 2:35 pm

    #955562

    Actually, it compresses it as it's saving it for both a time savings and disk storage savings right up front. And, restores are "snap" simple. I can see why it has won so many awards.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • March 8, 2009 at 6:24 am

    #955657

    Mohit (3/7/2009)

    Compression would be an option for you.

    I am not sure how well backups compress with standard compression tools; but tools like RedGate Backup work nicely to compress it before shipping it off.

    The compression (I use WinRAR) is quiet well for backup files. Just tried AdventureWorks. The backup file has 177mb the compressed archive has 25mb.

    Greets

    Flo

  • March 8, 2009 at 9:09 am

    #955667

    Its taking nearly 1.5hrs to copy 1.6GB files to the US server drives. Can i do this copy backup files much faster from Chennai (INDIA) to US server. We are not using any tools.

    Please suggest if thats possible by the existing.

    Thanks,

    CH&HU.

    I think that's an acceptable time over a network, the only option here we have is compressing the files and transferring them over. WinRAR performs will if you are not willing to buy any third party tools. But be sure to hold a copy of your backup files on your local server too as a best practice. I suppose you are doing it.

  • March 8, 2009 at 10:04 pm

    #955792

    Dear All,

    Thanks for your inputs. I tried using WinRAR it worked fine.

    Regards,

    CH&HU.

  • March 8, 2009 at 10:12 pm

    #955793

    CH&HU (3/8/2009)

    Dear All,

    Thanks for your inputs. I tried using WinRAR it worked fine.

    Regards,

    CH&HU.

    How much did it compress to? How long did it take to transfer it over to ur USA server? Just for info.....

  • March 9, 2009 at 1:24 am

    #955811

    Hi,

    It compreesed to 35 - 40 % , and the trasfer time is of 1hr .

Viewing 8 posts - 1 through 7 (of 7 total)

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