sql数据库自动备份

wsjz_01

if exist C:\BackupScript\BackupUF_Day.sql del C:\BackupScript\BackupUf_Day.sql　　＃建立SQL备份文件
　　echo use master;  C:\BackupScript\BackupUf_Day.sql
　　echo go  C:\BackupScript\BackupUf_Day.sql
　　echo Backup database UFDATA_003_2009 C:\BackupScript\BackupUf_Day.sql
　　＃备份数据库UFDATA_003_2009
　　echo to disk='d:\backup\UFDATA_003_2009_%date:~4,4%%date:~9,2%%date:~12,2%.bak'  C:\BackupScript\BackupUf_Day.sql
　　＃设定数据库备份路径的保存路径。其中%date:~4,4%%date:~9,2%%date:~12,2%这个参数是取当天的日期，它的意思是从data命令显示出来的数据中从第四位取起连续取四位数据做为第一部份，后面的意思相同。
　　echo with init,nounload;  C:\BackupScript\BackupUf_Day.sql
　　echo go  C:\BackupScript\BackupUf_Day.sql
　　echo use master;  C:\BackupScript\BackupUf_Day.sql
　　echo go  C:\BackupScript\BackupUf_Day.sql
　　echo Backup database UFDATA_105_2009 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 use master;  C:\BackupScript\BackupUf_Day.sql
　　echo go  C:\BackupScript\BackupUf_Day.sql
　　echo Backup database UFDATA_110_2009 C:\BackupScript\BackupUf_Day.sql
　　echo to disk='d:\backup\UFDATA_110_2009_%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 use master;  C:\BackupScript\BackupUf_Day.sql
　　echo go  C:\BackupScript\BackupUf_Day.sql
　　echo Backup database UFDATA_306_2009 C:\BackupScript\BackupUf_Day.sql
　　echo to disk='d:\backup\UFDATA_306_2009_%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