[EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [test] TO DISK = ''E:\Backups\<AUTO>_1.sqb'', DISK = ''E:\Backups\<AUTO>_2.sqb'', DISK = ''E:\Backups\<AUTO>_3.sqb'' WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4"'
How does the software determine the size of each file or how many files to split the backup into?
Is there a way to set a max size for each file?
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
Get the latest news and training with the monthly Redgate Update