Results 1 to 3 of 3

Thread: DLT Tape

  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Post Unanswered: DLT Tape

    ASE 11.9 database backup on nt4 with DLT tape take several hours (8h to do 30Go). Can i do something to reduce backup time

  2. #2
    Join Date
    Jun 2002
    Location
    Dublin, Ireland
    Posts
    23
    You could use the -m option in your backup server Run file. This will increase the amount of shared memory the backupserver uses when doing database dumps and loads. Here is an example of a backupserver run file that uses this option(i.e. 130mb of shared memory):

    /opt/sybase/ASE-12_0/bin/backupserver \
    -SXXXXX_prod_back \
    -e/opt/sybase/ASE-12_0/install/XXXX_prod_back.log \
    -N25 \
    -C20 \
    -M/opt/sybase/ASE-12_0/bin/sybmultbuf \
    -Lus_english \
    -Jutf8 \
    -m130

    P.S. Only do this of course if you have this amount of shared memory to spare. The backupserver releases the memory when it completes a db dump/load.
    Mark Sheehan,
    Senior Sybase DBA

  3. #3
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255

    Re: DLT Tape

    Originally posted by fgerard4
    ASE 11.9 database backup on nt4 with DLT tape take several hours (8h to do 30Go). Can i do something to reduce backup time
    Options ... in addition to the above ...
    1 Get a real OS to host your Sybase server.
    2 Stripe the backup. Get 3 more DLT drives, make them know to Sybase (sp_addumpdevice) and use 3 STRIPE options in the DUMP command. This will give you one database across 4 DLT tapes.
    3 DUMP to disk files (yes, you can stripe these as well) and then back these up to OS tape. Leave the last set on disk in order to avoid the two-step restoration process.
    4 If you have Sybase ASE on a unix system somewhere on your network, set it up as a remote server from your ASE/NT server and DUMP db AT REMOTE_BKP_SVR. Note this will impact the network for the duration but backing up 30gb on a decent unix takes minutes (seconds on a fibre channel).
    Last edited by DerekA; 09-24-02 at 02:52.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •