Post reply

backup- fastest

  • June 28, 2013 at 4:03 pm

    #279362

    Hi,

    If I have a 100 GB of database and what are the best best options if I need to take a backup( a fastest possible way) to the same server and to backup to a network location ?

    Thanks.

  • July 1, 2013 at 1:57 am

    #1628631

    It depends on the setup and secification of your environment. Backup to direct attached storage will probably be the fastest solution because you are not bind to the network bandwith. You can use compression to decrease the I/O size, but keep in mind compression will increase the CPU usage. To be secure you can copy the backupfile to a NAS or tape after it has been created.

    Of course: testing the possible solutions will give you a definite answer to your environment.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • July 1, 2013 at 2:27 am

    #1628636

    I agree that compression would probably help you out. There is an overhead with CPU for the compression algorithm, but in most cases that overhead is more than made up by the drop in the amount of data needed to be written to disk.

    Joie Andrew
    "Since 1982"

  • July 1, 2013 at 7:17 pm

    #1628885

    Sometimes splitting the backup to more than 1 file helps with performance a bit.

    --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)

Viewing 4 posts - 1 through 3 (of 3 total)

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