Splitting Backup files

E3xtc

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

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

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