This will compress and split a large database file and ftp it over the internet.
@setlocal
@echo off
@For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Set Month=%%A
Set Day=%%B
Set Year=%%C
)
Set AFILE=C:\DatabaseBackups\Data\db.bak
Set BFILE=d:\backup\Data
Set LFILE=d:\backup\Logs
set MYDATA=MyDatabasename
set PATH="C:\Program Files\WinRAR";%PATH%
cd c:
cd C:\DatabaseBackups\Data
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe" -E -Q "BACKUP DATABASE %MYDATA% TO DISK='%AFILE%'"
echo Y|copy %AFILE% %BFILE%
REM THiS SPLITS THE DATABASE BACKUP FILE INTO 25MB SECTIONS OF A RAR
echo Y|rar a -m5 -v25000k %Year%%Month%%Day% %AFILE%
ftp -s:cescript2.txt
ECHO Y |DEL %AFILE%
ECHO Y |DEL *.RAR