How can we help you today? How can we help you today?

Split backup - one thread for each file?

Right now I'm using THREADCOUNT = 2 to speed up my backup and restore. If I split the backup into two files instead of using THREADCOUNT (these options are mutually exclusive), will it automatically use one thread for each file? I want the performance boost of multiple threads and by putting each file on a different raid array.

Thanks
Keith_Walton
0

Comments

1 comment

Sort by
  • priyasinha
    Hi,

    Yes, if you use split file then SQL Backup will use one thread for each of the file.

    Thanks,
    Priya
    priyasinha
    0

Add comment

Please sign in to leave a comment.