批处理 全自动备份数据库(sql server)

  @echo off
::/开始设置/
::-------------------------------
::设置FTP服务器地址
set host=siyizhu.com
::设置FTP用户名
set user=Your username
::设置FTP密码
set password=password
::设置远程路径
set remotepatch=weblog/dbpatch
::设置要备份的文件名称
set bakfile=Databasename
::设置备份的文件格式
set bakpatch=asp
::设置备份到哪里<本地路径>
set bakpatch=F:/
::-------------------------------
::/结束设置/

::///不熟悉P处理的请务修改以下内容///

::生成FTP命令脚本
:index
cls
title 正在生成FTP备份脚本
echo ╔──────────────╗
echo │ 正在生成FTP备份脚本 │
echo ╚──────────────╝
echo open %host%>UP.TXT
echo %user%>>UP.TXT
echo %password%>>UP.TXT
echo ascii>>UP.TXT
echo cd %remotepatch%>>UP.TXT
echo prompt>>UP.TXT
echo lcd %bakpatch%>>UP.TXT
echo mget %bakfile%>>UP.TXT
echo bye>>UP.TXT
goto start

 

::运行FTP命令脚本
:start
cls
title SIYIZHU.COM数据库备份
echo ╔──────────────╗
echo │ SIYIZHU.COM数据库备份日志 │
echo ╚──────────────╝
echo -------------------------------------------------------------------------
echo 需要备份的文件:%host%/%remotepatch%/%bakfile%
echo 正在将其备份到:%bakpatch%
echo -------------------------------------------------------------------------
echo 需要的时间视您的网络情况以及要备份的文件大小而定,请耐心等待
echo.
echo 备份过程中,请不要关闭本程序,以免备份文件出错!
ftp -s:up.txt >nul

cls
::开始写入日志
echo ╔──────────────╗ >>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo │ SIYIZHU.COM数据库备份日志 │ >>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo ╚──────────────╝ >>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo ---------------------------------------->>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo 备份日期:%DATE% %TIME:~0,2%:%TIME:~3,2%:%TIME:~6,2% >>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo 备份文件:%host%/%remotepatch%/%bakfile% >>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo 备份路径:%bakpatch% >>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo ---------------------------------------->>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
echo ---------------------------------------->>"%userprofile%/桌面/SIYIZHU.COM备份日志.txt"
exit