Splitting Backup files
E3xtc
Posts: 7
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
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
Comments
Sorry guys, I have found the option in the drop down to split into multiple files.
:oops:
Cheers
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
Project Manager
Red Gate Software