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

Splitting Backup files

Hi,

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?

Cheers
Troy
E3xtc
0

Comments

2 comments

Sort by
  • E3xtc
    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.
    :oops:
    Cheers
    E3xtc
    0
  • priyasinha
    Hi,

    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.

    Regards,
    Priya
    priyasinha
    0

Add comment

Please sign in to leave a comment.