DosTips.com

Code: Select all

@echo off
color 0A

@REM - Schedule this to run in Control Panel, Scheduled Tasks 
@REM - Auto number backup filename


SET Server=.\SQLInstance
SET DBName=SQL
SET BackupPath=C:\SQLBackup
SET BackupName=SQLBackup
SET Ext=bak
SET i=0


@REM - Create Backup Folder
IF NOT EXIST %BackupPath% MKDIR %BackupPath%


@REM - Test which files exist already
:BEGINLOOP
SET /a i=%i%+1
SET file=%BackupPath%\%BackupName%%i%.%Ext%
if exist "%file%" GOTO BEGINLOOP
:ENDLOOP

echo writing backup to %file%
@echo off
osql -E -S %Server% -Q "backup database %DBName% to disk = '%file%'"

echo.
echo.
echo.
echo.
echo Backup Process is complete
echo For querys please contact our support desk
echo T: 01234 567 899  E: support@company.co.uk
echo.
echo.
echo.
@ECHO OFF

:choice
set /P c=Do you want to backup to Company Cloud Storage?[Y/N]?
if /I "%c%" EQU "Y" goto :backup
if /I "%c%" EQU "N" goto :exit
goto :choice


:backup

echo "Files are backing up to the Datatime Cloud..."
xcopy /c /k /o /v /y "C:\FocusBackup\*.bak" "ftp://XXX.XX.XX.XXX/public/SQLBackup/Company/"
pause
exit

:exit

echo "Backup Process has finished, files not uploaded."
pause 
exit

Code: Select all

@echo off
set "ftpScript=%temp%\%~nx0.ftp.tmp"
(
    echo open (ftp server name)
    echo (ftp user-name)
    echo (ftp password)
    echo prompt
    echo bin
    echo mput "C:\FocusBackup\*.bak"
    echo quit
) > "%ftpScript%"

ftp -s:"%ftpScript%"
del "%ftpScript%"

Code: Select all

@echo off
set "ftpScript=%temp%\%~nx0.ftp.tmp"
(
    echo open 188.39.138.35
    echo Customer
    echo Test1
    echo prompt
    echo bin
    echo CD MYDIR "FTP://188.39.138.35/public/customer backups/"
    echo mput "C:\FocusBackup\*.bak"
    echo quit
) > "%ftpScript%"

ftp -s:"%ftpScript%"
del "%ftpScript%"

Code: Select all

@echo off
set "ftpScript=%temp%\%~nx0.ftp.tmp"
(
    echo open 188.39.138.35
    echo Customer
    echo Test1
    echo prompt
    echo bin
    echo CD "/public/customer backups/"
    echo mput "C:\FocusBackup\*.bak"
    echo quit
) > "%ftpScript%"

ftp -s:"%ftpScript%"
del "%ftpScript%"