主题：[原创]放在局域网另一台电脑上的mdb数据库如何自动备份？

[原创]放在局域网另一台电脑上的mdb数据库如何自动备份？

 

如题，链接是下面的：

 

 
此主题相关图片如下：qq截图20130220155352.png

 

如何自动备份这个  xmxs.mdb 数据库呢？

只能是手工备份。比如 在打开或者关闭程序的时候，通过代码去备份。

FileSys.CopyFile("\\xxxxx\aaa$\xmxs.mdb", "\\xxxxxx\aaa$\bak\" & Format(date.Today, "yyyyMMdd") & ".mdb.bak", True)

http://www.foxtable.com/help/topics/0342.htm

@ECHO OFF

IF EXIST d:\hisbak\WEEK0.DMP D:\oracle\product\10.2.0\db_1\BIN\Exp.exe USERID=sys/XXXX@his buffer=4096 file=d:\hisbak\WeekBak0.dmp full=y
IF EXIST d:\hisbak\WEEK1.DMP D:\oracle\product\10.2.0\db_1\BIN\Exp.exe USERID=sys/XXXX@his buffer=4096 file=d:\hisbak\WeekBak1.dmp full=y
IF EXIST d:\hisbak\WEEK2.DMP D:\oracle\product\10.2.0\db_1\BIN\Exp.exe USERID=sys/XXXX@his buffer=4096 file=d:\hisbak\WeekBak2.dmp full=y
IF EXIST d:\hisbak\WEEK3.DMP D:\oracle\product\10.2.0\db_1\BIN\Exp.exe USERID=sys/XXXX@his buffer=4096 file=d:\hisbak\WeekBak3.dmp full=y
IF EXIST d:\hisbak\WEEK4.DMP D:\oracle\product\10.2.0\db_1\BIN\Exp.exe USERID=sys/XXXX@his buffer=4096 file=d:\hisbak\WeekBak4.dmp full=y
IF EXIST d:\hisbak\WEEK5.DMP D:\oracle\product\10.2.0\db_1\BIN\Exp.exe USERID=sys/XXXX@his buffer=4096 file=d:\hisbak\WeekBak5.dmp full=y
IF EXIST d:\hisbak\WEEK6.DMP D:\oracle\product\10.2.0\db_1\BIN\Exp.exe USERID=sys/XXXX@his buffer=4096 file=d:\hisbak\WeekBak6.dmp full=y

IF EXIST d:\hisbak\WEEK6.DMP REN d:\hisbak\WEEK6.DMP WEEK7.DMP
IF EXIST d:\hisbak\WEEK5.DMP REN d:\hisbak\WEEK5.DMP WEEK6.DMP
IF EXIST d:\hisbak\WEEK4.DMP REN d:\hisbak\WEEK4.DMP WEEK5.DMP
IF EXIST d:\hisbak\WEEK3.DMP REN d:\hisbak\WEEK3.DMP WEEK4.DMP
IF EXIST d:\hisbak\WEEK2.DMP REN d:\hisbak\WEEK2.DMP WEEK3.DMP
IF EXIST d:\hisbak\WEEK1.DMP REN d:\hisbak\WEEK1.DMP WEEK2.DMP
IF EXIST d:\hisbak\WEEK0.DMP REN d:\hisbak\WEEK0.DMP WEEK1.DMP
IF EXIST d:\hisbak\WEEK7.DMP REN d:\hisbak\WEEK7.DMP WEEK0.DMP

@ECHO ON

以上是我们数据库中的一个“葫芦”，看你能否画出个瓢来，这是一个批处理文件，再建一个任务计划，按时执行。

 楼上方法挺好，用批处理和任务计划比较好。

 新建一个文本文件，输入如下内容，设置好路径。

echo off
echo 正在准备备份mdb数据库

xcopy "d:\test.mdb" /f "d:\bak\%date:/=%.mdb.bak" /y

echo 等候关闭
pause

 把后缀名改成.bat，然后在服务器电脑上设置任务计划，控制面板那里。