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

asked Mar 2, 2018 at 13:31
2
  • 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. Commented Mar 2, 2018 at 13:38
  • 1
    see if my answer helps you. You can use powershell to perform backups in parallel. Commented Mar 2, 2018 at 14:52

1 Answer 1

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 ♦
71.1k22 gold badges178 silver badges324 bronze badges
answered Mar 2, 2018 at 13:44
7
  • 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 Commented Mar 3, 2018 at 9: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. Commented Mar 3, 2018 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 Commented Mar 5, 2018 at 15:10
  • Have you looked at option D in this link ? 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? Commented Mar 7, 2018 at 4:48
  • yes I did that, now all big backups completing within time, thank you very much for your quick response Commented Mar 7, 2018 at 13:35

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.