黑色海岸线论坛 - Powered by Discuz! Board

@echo 创建备份目录
set Timea=%date:~0,4%_%date:~5,2%_%date:~8,2%
set Timeb=%date:~0,4%-%date:~5,2%-%date:~8,2%
Rem IIS
md Z:\IISBackup\%Timeb%\
Rem FTP
md Z:\Serv-UBackup\%Timeb%\
Rem Mail
md Z:\WinWebmailBackup\%Timeb%\
Rem Site
md Z:\SiteBackup\%Timeb%\
Rem DataBase
md Z:\数据库\%Timeb%\
@echo 备份论坛数据库
isql.exe -S (local) -U 用户名 -P 密码 -i backup_bbs.sql
@echo 备份IIS配置
iisback /backup /b %Timea%
copy C:\WINDOWS\system32\inetsrv\MetaBack\%Timea%.MD0 Z:\IISBackup\%Timeb%\%Timea%.MD0
copy C:\WINDOWS\system32\inetsrv\MetaBack\%Timea%.SC0 Z:\IISBackup\%Timeb%\%Timea%.SC0
@echo 备份FTP配置
copy C:\Program Files\Serv-U\ServUAdmin.ini Z:\Serv-UBackup\%Timeb%\ServUAdmin.ini
copy C:\Program Files\Serv-U\ServUDaemon.ini Z:\Serv-UBackup\%Timeb%\ServUDaemon.ini
@echo 备份Mail配置
copy C:\WinWebMail\backup\Sysbak%Timeb%.zip Z:\WinWebmailBackup\%Timeb%\Sysbak.zip
@echo 开始备份网站
ar a -k -r -s -m1 Z:\SiteBackup\%Timeb%\www_163_net.rar Y:\WebSite\www_163_net\
rar a -k -r -s -m1 Z:\SiteBackup\%Timeb%\www_cctv_com.rar Y:\WebSite\www_cctv_com\
rar a -k -r -s -m1 Z:\SiteBackup\%Timeb%\www_xinhuanet_com.rar Y:\WebSite\www_xinhuanet_com\

复制代码

DECLARE @name varchar(50)
DECLARE @datetime char(14)
DECLARE @path varchar(255)
DECLARE @bakfile varchar(255)
set @name='My_BBS'
--set @datetime=CONVERT(char(8),getdate(),112) + REPLACE(CONVERT(char(8),getdate(),108),':','')
set @datetime=REPLACE(CONVERT(char(10),getdate(),111),'/','-')
set @path='Z:\数据库\'+@datetime
set @bakfile=@path+'\'+'Bak_'+@datetime+'_'+@name+'.bak'
set @bakfile=REPLACE(@bakfile,' ','')
backup database @name to disk=@bakfile with name=@name
go

复制代码