backup database #YourDB# to disk='D:\Backup\#YourDB#.bak' with buffercount=7 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=7 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=7 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=7 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=7 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=12 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=12 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=12 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=12 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=12 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=17 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=17 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=17 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=17 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=17 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=27 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=27 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=27 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=27 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=27 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=37 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=37 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=37 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=37 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=37 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=47 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=47 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=47 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=47 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=47 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go -------------------------------------------------------------------------------------------------------------- backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go ----------------------------------------------------------------- backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=7, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=7, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=7, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=7, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=7, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=12, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=12, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=12, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=12, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=12, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=17, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=17, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=17, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=17, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=17, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=27, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=27, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=27, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=27, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=27, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=37, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=37, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=37, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=37, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=37, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=47, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=47, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=47, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=47, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak' with buffercount=47, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go ---------------- backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=7, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=7, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=7, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=7, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=7, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=12, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=12, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=12, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=12, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=12, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=17, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=17, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=17, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=17, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=17, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=27, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=27, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=27, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=27, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=27, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=37, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=37, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=37, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=37, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=37, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=47, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=47, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=47, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=47, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak' with buffercount=47, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go ---------------- backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=7, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=7, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=7, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=7, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=7, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=12, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=12, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=12, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=12, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=12, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=17, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=17, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=17, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=17, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=17, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=27, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=27, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=27, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=27, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=27, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=37, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=37, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=37, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=37, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=37, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=47, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=47, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=47, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=47, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak' with buffercount=47, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go ---------------- backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=7, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=7, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=7, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=7, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=7, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=12, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=12, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=12, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=12, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=12, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=17, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=17, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=17, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=17, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=17, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=27, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=27, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=27, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=27, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=27, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=37, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=37, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=37, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=37, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=37, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=47, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=47, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=47, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=47, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak' with buffercount=47, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go ---------------- backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=7, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=7, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=7, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=7, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=7, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=12, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=12, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=12, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=12, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=12, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=17, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=17, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=17, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=17, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=17, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=27, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=27, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=27, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=27, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=27, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=37, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=37, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=37, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=37, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=37, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=47, maxtransfersize=131072 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=47, maxtransfersize=524288 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=47, maxtransfersize=1048576 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=47, maxtransfersize=2097152 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go backup database #YourDB# to disk='D:\backup\#YourDB#.bak',disk='D:\backup\#YourDB#2.bak',disk='D:\backup\#YourDB#3.bak',disk='D:\backup\#YourDB#4.bak',disk='D:\backup\#YourDB#5.bak' with buffercount=47, maxtransfersize=4194304 go xp_cmdshell 'del D:\backup\#YourDB#*.bak' go ----------------