今天上午把公司的ERP的数据库摸了一下底，库文件居然是这么乱放的。。。。。。。。。
@echo off
dir E:\U8SOFT\Admin\ERP\combase_Data.MDF | find "2007"
dir E:\UFDATABASE\ZT001\2002\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT001\2003\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT001\2004\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT001\2005\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT201\2003\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT201\2004\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT201\2005\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT201\2006\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ERP\ZT201\2007\UFDATA.MDF | find "2007"
dir E:\UFDATABASE\ZT202\2005\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT202\2006\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ERP\ZT202\2007\UFDATA.MDF | find "2007"
dir E:\UFDataBase\ZT222\2005\UFDATA.MDF | find "2007"
dir E:\UFDATABASE\ZT222\2006\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT333\2007\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT444\2007\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT888\ZT888\2005\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT888\ZT888\2006\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT888\ZT888\2007\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT999\ZT999\2005\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT999\ZT999\2006\ufdata.mdf | find "2007"
dir E:\UFDATABASE\ZT999\ZT999\2007\ufdata.mdf | find "2007"
dir D:\U8SOFT\Admin\ERP\ufsub.mdf | find "2007"
dir D:\U8SOFT\Admin\ERP\UFSystem.MDF | find "2007"

结果：
2007-12-13 10:32 2,818,048 combase_Data.MDF
2007-12-09 04:30 154,206,208 ufdata.mdf
2007-12-13 11:04 169,672,704 ufdata.mdf
2007-12-13 11:04 169,672,704 ufdata.mdf
2007-12-13 11:05 169,672,704 ufdata.mdf
2007-12-13 11:05 154,206,208 ufdata.mdf
2007-12-13 11:05 154,206,208 ufdata.mdf
2007-12-13 11:05 154,206,208 ufdata.mdf
2007-12-13 11:05 170,459,136 ufdata.mdf
2007-12-13 11:05 170,459,136 UFDATA.MDF
2007-12-13 11:06 170,459,136 ufdata.mdf
2007-12-13 11:06 170,459,136 ufdata.mdf
2007-12-13 11:06 170,459,136 UFDATA.MDF
2007-12-13 11:06 170,459,136 UFDATA.MDF
2007-12-13 11:06 170,459,136 ufdata.mdf
2007-12-13 11:06 187,498,496 ufdata.mdf
2007-12-13 11:06 170,459,136 ufdata.mdf
2007-12-13 11:07 862,191,616 ufdata.mdf
2007-12-13 11:08 1,313,472,512 ufdata.mdf
2007-12-13 11:08 566,231,040 ufdata.mdf
2007-12-13 11:09 862,191,616 ufdata.mdf
2007-12-13 11:10 1,313,472,512 ufdata.mdf
2007-12-13 01:00 1,472,200,704 ufdata.mdf
2007-12-09 04:30 10,485,760 ufsub.mdf
2007-12-13 08:49 390,397,952 UFSystem.MDF

然后又做了一个自动把这些全部备份的SQL脚本，结果：
E:\dbbackup 的目录

2007-12-13 11:11 <DIR> .
2007-12-13 11:11 <DIR> ..
2007-12-13 11:04 2,507,264 DBbk2007-12-13T11_04_19_377#combase.dbk
2007-12-13 11:04 150,225,408 DBbk2007-12-13T11_04_19_377#UFDATA_001_2002.dbk
2007-12-13 11:04 157,303,296 DBbk2007-12-13T11_04_19_377#UFDATA_001_2003.dbk
2007-12-13 11:04 161,563,136 DBbk2007-12-13T11_04_19_377#UFDATA_001_2004.dbk
2007-12-13 11:05 157,106,688 DBbk2007-12-13T11_04_19_377#UFDATA_001_2005.dbk
2007-12-13 11:05 144,785,920 DBbk2007-12-13T11_04_19_377#UFDATA_201_2003.dbk
2007-12-13 11:05 141,378,048 DBbk2007-12-13T11_04_19_377#UFDATA_201_2004.dbk
2007-12-13 11:05 143,802,880 DBbk2007-12-13T11_04_19_377#UFDATA_201_2005.dbk
2007-12-13 11:05 143,147,520 DBbk2007-12-13T11_04_19_377#UFDATA_201_2006.dbk
2007-12-13 11:05 142,885,376 DBbk2007-12-13T11_04_19_377#UFDATA_201_2007.dbk
2007-12-13 11:06 152,584,704 DBbk2007-12-13T11_04_19_377#UFDATA_202_2005.dbk
2007-12-13 11:06 142,819,840 DBbk2007-12-13T11_04_19_377#UFDATA_202_2006.dbk
2007-12-13 11:06 142,950,912 DBbk2007-12-13T11_04_19_377#UFDATA_202_2007.dbk
2007-12-13 11:06 153,829,888 DBbk2007-12-13T11_04_19_377#UFDATA_222_2005.dbk
2007-12-13 11:06 142,885,376 DBbk2007-12-13T11_04_19_377#UFDATA_222_2006.dbk
2007-12-13 11:06 176,308,736 DBbk2007-12-13T11_04_19_377#UFDATA_333_2007.dbk
2007-12-13 11:06 158,679,552 DBbk2007-12-13T11_04_19_377#UFDATA_444_2007.dbk
2007-12-13 11:07 757,088,768 DBbk2007-12-13T11_04_19_377#UFDATA_888_2005.dbk
2007-12-13 11:08 1,027,817,984 DBbk2007-12-13T11_04_19_377#UFDATA_888_2006.dbk
2007-12-13 11:08 428,753,408 DBbk2007-12-13T11_04_19_377#UFDATA_888_2007.dbk
2007-12-13 11:09 757,547,520 DBbk2007-12-13T11_04_19_377#UFDATA_999_2005.dbk
2007-12-13 11:10 993,608,192 DBbk2007-12-13T11_04_19_377#UFDATA_999_2006.dbk
2007-12-13 11:11 1,159,419,392 DBbk2007-12-13T11_04_19_377#UFDATA_999_2007.dbk
2007-12-13 11:11 3,947,008 DBbk2007-12-13T11_04_19_377#UFPortal.dbk
2007-12-13 11:11 1,589,760 DBbk2007-12-13T11_04_19_377#UFSub.dbk
2007-12-13 11:11 360,661,504 DBbk2007-12-13T11_04_19_377#UFSystem.dbk
26 个文件 7,905,198,080 字节

也将近8G了，放到虚拟机里，会不会性能很低啊。。。。。。。。