What are the challenges you face when working across database platforms? Take the survey
Options

Can I have multiple SQL Backup run on the same server

gsc_ghxgsc_ghx Posts: 73
edited March 6, 2012 11:17PM in SQL Backup Previous Versions
Can I have multiple SQL Backup run on the same server - Multi threading?

I have a server that has 1200 db's on it - it takes over 14 hours to back these db's up. I would like to have more than one backup running at one time - can SQL Backup 6.4.0.56 PRO do multi-threading? If so - how do I put this in my proc (sql stmt) that we call for our backup job.

Thanks
Geri
:?:

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Just create multiple jobs, each one backing up a different set of databases.

    The limiting factor would be your disk and CPU subsystems - are your database files all on the same or different set of disks, are you writing the backup files to the same or different set of disks, do you have enough CPU capacity to service the various backup threads etc.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    We backup to a backup share - hosted on a VM windows machine.

    Thanks Petey.
Sign In or Register to comment.