Red Gate forums :: View topic - Can I have multiple SQL Backup run on the same server
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Can I have multiple SQL Backup run on the same server

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
gsc_ghx



Joined: 04 Dec 2007
Posts: 51

PostPosted: Tue Mar 06, 2012 6:47 pm    Post subject: Can I have multiple SQL Backup run on the same server Reply with quote

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
Question
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Wed Mar 07, 2012 3:50 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
gsc_ghx



Joined: 04 Dec 2007
Posts: 51

PostPosted: Wed Mar 07, 2012 5:17 am    Post subject: Reply with quote

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

Thanks Petey.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group