[url]http://www.jsiinc.com/sube/tip2200/rh2265.htm[/url]
[url]http://www.jsiinc.com/SUBL/tip5900/rh5955.htm[/url]
[url]http://www.jsiinc.com/subj/tip4700/rh4721.htm[/url]
[url]http://www.jsiinc.com/sube/tip2100/rh2148.htm[/url]
[url]http://www.jsiinc.com/SUBJ/tip4500/rh4540.htm[/url]
if exist z: net use z: /delete
net use z: \\192.168.42.6\exbak pass83 /user:xon\administrator
if exist backup.log del backup.log
ipconfig backup.log
C:\BackupScript\blat.exe -install 192.168.42.15 [email]mail@126.com[/email]
if not exist z: (goto Fail) else (goto ok)
:Fail
echo %date%:%time%Backup of UF DataBase of Day Fail backup.log
echo Network services is not unaccess backup.log
C:\BackupScript\blat.exe C:\BackupScript\backup.log -to [email]mail@126.com[/email] -s "Day Backup Fail" -u [email]mail@126.com[/email] -pw password
goto end
:OK
if exist C:\BackupScript\BackupUF_Day.sql del C:\BackupScript\BackupUf_Day.sql
echo go C:\BackupScript\BackupUf_Day.sql
echo Backup database UFDATA_002_2008 C:\BackupScript\BackupUf_Day.sql
echo to disk='d:\backup\UFDATA_002_2008_%date:~4,4%%date:~9,2%%date:~12,2%.bak' C:\BackupScript\BackupUf_Day.sql
echo go C:\BackupScript\BackupUf_Day.sql
echo Backup database UFDATA_105_2008 C:\BackupScript\BackupUf_Day.sql
echo to disk='d:\backup\UFDATA_105_2008_%date:~4,4%%date:~9,2%%date:~12,2%.bak' C:\BackupScript\BackupUf_Day.sql
echo with init,nounload; C:\BackupScript\BackupUf_Day.sql
echo go C:\BackupScript\BackupUf_Day.sql
echo go C:\BackupScript\BackupUf_Day.sql
echo Backup database UFDATA_110_2008 C:\BackupScript\BackupUf_Day.sql
echo to disk='d:\backup\UFDATA_110_2008_%date:~4,4%%date:~9,2%%date:~12,2%.bak' C:\BackupScript\BackupUf_Day.sql
echo with init,nounload; C:\BackupScript\BackupUf_Day.sql
echo go C:\BackupScript\BackupUf_Day.sql
echo go C:\BackupScript\BackupUf_Day.sql
echo Backup database UFDATA_306_2008 C:\BackupScript\BackupUf_Day.sql
echo to disk='d:\backup\UFDATA_306_2008_%date:~4,4%%date:~9,2%%date:~12,2%.bak' C:\BackupScript\BackupUf_Day.sql
echo with init,nounload; C:\BackupScript\BackupUf_Day.sql
echo go C:\BackupScript\BackupUf_Day.sql
echo Waitting..... backup.log
"C:\PROGRA~1\Microsoft SQL Server\80\Tools\Binn\OSQL.exe" -S localhost -U sa -P -i C:\BackupScript\BackupUf_Day.sql -o C:\BackupScript\UF_%date:~4,4%%date:~9,2%%date:~12,2%.log
echo %date%:%time%Backup of UFserver DataBase backup.log
echo Waiting...... backup.log
set /a Days=%date:~4,4%%date:~9,2%%date:~12,2%
C:\BackupScript\forfiles_20.exe -pd:\backup\ -d-0 -mUF*_2008_%days%.bak -c"cmd /c copy @FILE z:\UF\"
C:\BackupScript\forfiles_20.exe -pd:\backup\ -d-7 -mUF*_2008_*.bak -c"cmd /c del @FILE"
C:\BackupScript\forfiles_20.exe -pz:\UF\ -d-7 -mUF*_2008_*.bak -c"cmd /c del @FILE"
if not exist z:\uf\UF*%days%.bak goto Fail
echo %date%:%time%Day Backup of UF DataBase Sucess backup.log
C:\BackupScript\blat.exe C:\BackupScript\backup.log -to [email]mail@126.com[/email] -s "Day Backup UF Sucess" -u [email]mail@126.com[/email] -pw P@$$w0rd -attacht C:\BackupScript\UF_%date:~4,4%%date:~9,2%%date:~12,2%.log
:end
del backup.log
net use z: /delete
del C:\BackupScript\BackupUf_Day.sql
del C:\BackupScript\UF_%date:~4,4%%date:~9,2%%date:~12,2%.log