What are the challenges you face when working across database platforms? Take the survey

Splitting Backup files

E3xtcE3xtc Posts: 7
edited April 14, 2009 5:32AM in SQL Backup Previous Versions

Just a quick question; is there any way that SQL Backup can split a backup file into multiple files to potentially increase the throughput and decrease backup times?
I understand that SQL Litespeed does this and it can improve times considerably.

We are not in a situation where we are blowing out our backup window, but we are looking for ways to streamline and improve times where possible; and as a result this was raised. :)

Any ideas?



  • Options
    I know; how about I open my eyes and actually look at the screen *groan*

    Sorry guys, I have found the option in the drop down to split into multiple files.
  • Options

    Apart from using split files, you can also try different compression levels too. Try using THREADCOUNT also. It is always better to do a backup locally and then use COPYTO to copy the backup files rather than backing to the network directly (depending on external network resources, backup performance becomes less predictable).

    Hope this helps.

    Priya Sinha
    Project Manager
    Red Gate Software
Sign In or Register to comment.