[原创] 再发懒人专用备份工具包

手动备份，不是懒人滴风格。。

偶们让批处理来完成这一切吧。。一键备份数据库，网站数据，IIS配置，FTP配置，MAIL配置。。

backup.bat

1. @echo 创建备份目录
   
2. set Timea=%date:~0,4%_%date:~5,2%_%date:~8,2%
   
3. set Timeb=%date:~0,4%-%date:~5,2%-%date:~8,2%
   
4. Rem IIS
   
5. md Z:\IISBackup\%Timeb%\
   
6. Rem FTP
   
7. md Z:\Serv-UBackup\%Timeb%\
   
8. Rem Mail
   
9. md Z:\WinWebmailBackup\%Timeb%\
   
10. Rem Site
    
11. md Z:\SiteBackup\%Timeb%\
    
12. Rem DataBase
    
13. md Z:\数据库\%Timeb%\
    
14. 
    
15. @echo 备份论坛数据库
    
16. isql.exe -S (local) -U 用户名 -P 密码 -i backup_bbs.sql
    
17. 
    
18. @echo 备份IIS配置
    
19. iisback /backup /b %Timea%
    
20. copy C:\WINDOWS\system32\inetsrv\MetaBack\%Timea%.MD0 Z:\IISBackup\%Timeb%\%Timea%.MD0
    
21. copy C:\WINDOWS\system32\inetsrv\MetaBack\%Timea%.SC0 Z:\IISBackup\%Timeb%\%Timea%.SC0
    
22. 
    
23. @echo 备份FTP配置
    
24. copy C:\Program Files\Serv-U\ServUAdmin.ini Z:\Serv-UBackup\%Timeb%\ServUAdmin.ini
    
25. copy C:\Program Files\Serv-U\ServUDaemon.ini Z:\Serv-UBackup\%Timeb%\ServUDaemon.ini
    
26. 
    
27. @echo 备份Mail配置
    
28. copy C:\WinWebMail\backup\Sysbak%Timeb%.zip Z:\WinWebmailBackup\%Timeb%\Sysbak.zip
    
29. 
    
30. @echo 开始备份网站
    
31. ar a -k -r -s -m1 Z:\SiteBackup\%Timeb%\www_163_net.rar Y:\WebSite\www_163_net\
    
32. 
    
33. rar a -k -r -s -m1 Z:\SiteBackup\%Timeb%\www_cctv_com.rar Y:\WebSite\www_cctv_com\
    
34. 
    
35. rar a -k -r -s -m1 Z:\SiteBackup\%Timeb%\www_xinhuanet_com.rar Y:\WebSite\www_xinhuanet_com\

复制代码

开始备份.bat

1. set a=%date:~0,4%_%date:~5,2%_%date:~8,2%
   
2. Backup.bat>\备份日志\%a%.log

复制代码

backup_bbs.sql

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

复制代码

[ 本帖最后由 chinanic 于 2007-10-31 15:26 编辑 ]