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

Improve this question
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.
    – Jonathan Fite
    Commented Mar 2, 2018 at 13:38
  • 1
    see if my answer helps you. You can use powershell to perform backups in parallel.
    – Kin Shah
    Commented Mar 2, 2018 at 14:52

1 Answer 1

Reset to default
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.

Improve this answer
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
    – ven
    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.
    – Laurent
    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
    – ven
    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?
    – Laurent
    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
    – ven
    Commented Mar 7, 2018 at 13:35

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.