Can I have multiple SQL Backup run on the same server

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Can I have multiple SQL Backup run on the same server

Postby gsc_ghx » Tue Mar 06, 2012 6:47 pm

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
:?:
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm

Postby petey » Wed Mar 07, 2012 3:50 am

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 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby gsc_ghx » Wed Mar 07, 2012 5:17 am

We backup to a backup share - hosted on a VM windows machine.

Thanks Petey.
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests