最近客户要求系统的数据库每天备份一次,总是保留最近一个星期的备份文件,写了一个脚本,也许有朋友会用到
新建bat文件
--------------------------------------------------------------------------
del d:/dbbak/bak7.dmp
ren d:/dbbak/bak6.dmp bak7.dmp
ren d:/dbbak/bak5.dmp bak6.dmp
ren d:/dbbak/bak4.dmp bak5.dmp
ren d:/dbbak/bak3.dmp bak4.dmp
ren d:/dbbak/bak2.dmp bak3.dmp
ren d:/dbbak/bak.dmp bak2.dmp
exp vshop/vshop@local owner=vshop file=d:/dbbak/bak.dmp
---------------------------------------------------------------------------
放在任务计划里每天执行一遍就可以了
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/johnson_hong/archive/2008/09/04/2878458.aspx