0

Currently I am using ola hallengren backup and maintenance scripts.

I have a question:

I have 5 big databases in one server. It's taking approximate 10+ hours everyday to complete full backups. Currently it's writing in sequentially into disk.

I want to write all backups parallel to reduce time. Is there any way I can write backups parallel?

I am taking compressed and verify only backups to network location

ven
  • 13
  • 1
  • 6
  • 1
    Define "Big"? Honestly, your best and easiest way to faster full backups will be to write to multiple files. specify the Number Of Files option when taking the backup using Ola's scripts. To actually run in parallel, just create multiple jobs to run at the same time and specify the database names. – Jonathan Fite Mar 02 '18 at 13:38
  • 1
    see if my answer helps you. You can use powershell to perform backups in parallel. – Kin Shah Mar 02 '18 at 14:52

1 Answers1

5

Create additional jobs to run backups in parallel. Make sure to specify a single unique database per job. Configure the SQL Server Agent jobs to start the backup at approximately same time, with a 1 minute delay between each job.

You may find that running backup jobs simultaneously does not significantly decrease backup time. You should evaluate the I/O capability of the disks where the databases reside, the disks where the backups are being written to, and in the case of network backups, the capacity of the network to transfer data.

Hannah Vernon
  • 70,041
  • 22
  • 171
  • 315
Laurent
  • 73
  • 1
  • 8
  • thanks for above input, I created additional jobs to run backups in parallel. but one of the DB taking 10:30 hours total backup time. but backup size is 349 GB, please suggest me how to reduce backup time – ven Mar 03 '18 at 09:00
  • 349Gb is the compressed backup size Right? Are you backing it up to local disk or UNC path? Are the I/O on the backup device fast? Last thing you should try is definitely split up the files like Ven suggested. – Laurent Mar 03 '18 at 12:47
  • Yes, this is a compressed backup. I am using network share location to save backup files, I am using ola hallengren scripts for backup solution, I am not sure how to use Ola scripts to split backups files – ven Mar 05 '18 at 15:10
  • Have you looked at option D in this link ? https://ola.hallengren.com/sql-server-backup.html . Be sure to test it out on a test environment first. Maybe try splitting to 10 files first? – Laurent Mar 07 '18 at 04:48
  • yes I did that, now all big backups completing within time, thank you very much for your quick response – ven Mar 07 '18 at 13:35
  • Awesome! Do you mind sharing how many files you split into and how long did it take the complete a backup? – Laurent Mar 07 '18 at 13:36
  • I did for 10 files, it took1 hour to complete backup. thanks to all – ven Mar 08 '18 at 16:27