删除历史年度数据只保留091011三个年度.doc

因为PMC计算等原因，每天起数据库2-3次或以上。而新中大软件老厂帐套中，保留了多年的数据。目标：准备只保留09、10、11年度的数据，其余年度的数据，如果测试备份可以删除后INSERT回来，则将会删除他们。？1、备份（数据库备份、新中大备份（开始删除之前的数据备份，开始删除数据之后的备份）2、删除了哪些表的内容，截至日期3、ID号？以下使用的为lxz个人电脑上数据库中的数据。其数据只保留到了2008年8月29日。一、利用企业管理器备份数据库至E:李宪忠本机数据backup，时间为20110105备份开始时间为22：13FAT32文件系统中，文件最大不能超过4GB怎么办？因为E盘为FAT32位分区，所以备份不能成功NTFS分区最大支持多大的文件？2T应该是指支持的分区大小，64G就应该是文件的大小了我想把自己的D盘转成ntfs格式的，要怎么转，谁能说下流程二楼说的很好，看起来有点烦琐！简而言之：开始运行cmdconvert d:/fs:ntfs 记住此次转换D盘存储文件不会丢失，但此过程不可逆！不懂直接留言！245438225 Win 2000/XP 自带了将FAT或FAT32分区转换成NTFS分区的一个小程序Convert.exe，它不但转换速度快、简单易用，而且原来该分区上的数据还可以继续保存下来 在开始菜单-运行，输入“Convert C: /fs:ntfs”；如果要转换D盘，只要将“C:”改成相应的“D:”即可。转换完成后，它会向你报告你所转换的磁盘分区情况。 注意事项: 1、建议先执行磁盘扫描、磁盘碎片整理程序。 2、如果你要转换的FAT或FAT32分区上面有文件正被系统使用，那么在转换时，转换程序将会询问你是否卸下要转换的卷（即分区），这时最好选择“否”，最后它就会询问你是否在下一次计算机启动时转换分区，选择“是”并重新启动机器即可完成转换。E:李宪忠本机数据backup目录下，拷贝了测试使用的数据库，且准备备份测试使用的数据库。二、建立了一个数据为ng0001bf将操作的每张表从ng0001数据库备份至到ng0001bf数据库select * into ng0001bf.dbo.ordermst from ng0001.dbo.ordermst（所影响的行数为 42467 行）select count(*) from ng0001.dbo.ordermstselect * from ordermstselect substring(sysno,1,3),count(*) from ng0001.dbo.ordermst group by substring(sysno,1,3)P05381P0614833P0718211P089042准备将05年及06年数据删除。-1 ordermst orderdetselect substring(sysno,1,3),count(*) from orderdet group by substring(sysno,1,3)select * from ordermst where sysno like P05%or sysno like P06% or sysno like P07%or sysno like P08% delete from ordermst where sysno like P05%or sysno like P06% or sysno like P07%or sysno like P08% delete from orderdetwhere sysno like P05%or sysno like P06% or sysno like P07%or sysno like P08% -select sysno from sendmst where sysno like Q05%or sysno like Q06% or sysno like Q07%or sysno like Q08% order by sysnodelete from sendmst where sysno like Q05%or sysno like Q06% or sysno like Q07%or sysno like Q08% delete from senddetwhere sysno like Q05%or sysno like Q06% or sysno like Q07%or sysno like Q08% -select sysno from sbackdetwhere sysno like S05%or sysno like S06% or sysno like S07%or sysno like S08% ORDER BY SYSNO DELETE from sbackdetwhere sysno like S05%or sysno like S06% or sysno like S07%or sysno like S08% DELETE from sbackmstwhere sysno like S05%or sysno like S06% or sysno like S07%or sysno like S08% -delete from sbillmstwhere sysno like S05%or sysno like S06% or sysno like S07%or sysno like S08% delete from sbilldetwhere sysno like S05%or sysno like S06% or sysno like S07%or sysno like S08% select sysno from sbillmstwhere sysno like Q05%or sysno like Q06% or sysno like Q07%or sysno like Q08% delete from sbillmstwhere sysno like Q05%or sysno like Q06% or sysno like Q07%or sysno like Q08% delete from sbilldetwhere sysno like Q05%or sysno like Q06% or sysno like Q07%or sysno like Q08% -select spurno from purmstwhere spurno like G05%or spurno like G06% or spurno like G07%or spurno like G08% delete from purmstwhere spurno like G05%or spurno like G06% or spurno like G07%or spurno like G08% delete from purdecwhere spurno like G05%or spurno like G06% or spurno like G07%or spurno like G08% -select srtnno from rtnmstwhere srtnno like J05%or srtnno like J06% or srtnno like J07%or srtnno like J08% delete from rtnmstwhere srtnno like J05%or srtnno like J06% or srtnno like J07%or srtnno like J08% delete from rtndecwhere srtnno like J05%or srtnno like J06% or srtnno like J07%or srtnno like J08% -select srecno from recmstwhere srecno like 205%or srecno like 206% or srecno like 207%or srecno like 208% delete from recmstwhere srecno like 205%or srecno like 206% or srecno like 207%or srecno like 208% delete from recdetwhere srecno like 205%or srecno like 206% or srecno like 207%or srecno like 208% -select srcvno from rcvmstwhere srcvno like K05%or srcvno like K06% or srcvno like K07%or srcvno like K08% DELETE from rcvmstwhere srcvno like K05%or srcvno like K06% or srcvno like K07%or srcvno like K08% DELETE from rcvdetwhere srcvno like K05%or srcvno like K06% or srcvno like K07%or srcvno like K08% -select ordno from mps_mfg_ordwhere ordno like N05%or ordno like N06% or ordno like N07%or ordno like N08% ORDER BY ordnodelete from mps_mfg_ordwhere ordno like N05%or ordno like N06% or ordno like N07%or ordno like N08% select ordno from mps_mfg_detwhere ordno like N05%or ordno like N06% or ordno like N07%or ordno like N08% delete from mps_mfg_detwhere ordno like N05%or ordno like N06% or ordno like N07%or ordno like N08% -select ordno from mps_allocationwhere ordno like N05%or ordno like N06% or ordno like N07%or ordno like N08% delete from mps_allocationwhere ordno like N05%or ordno like N06% or ordno like N07%or ordno like N08% -select req_no from mrp_req_detwhere req_no like R05%or req_no like R06% or req_no like R07%or req_no like R08% delete from mrp_req_detwhere req_no like R05%or req_no like R06% or req_no like R07%or req_no like R08% -select sysno from mdm_proc_reqdtlwhere sysno like U05%or sysno like U06% or sysno like U07%or sysno like U08% delete from mdm_proc_reqdtlwhere sysno like U05%or sysno like U06% or sysno like U07%or sysno like U08% delete from mdm_proc_reqmstwhere sysno like U05%or sysno like U06% or sysno like U07%or sysno like U08% -select bmordno from mps_back_makeupwhere bmordno like 2005%or bmordno like 2006% or bmordno like 2007%or bmordno like 2008% delete from mps_back_makeupwhere bmordno like 2005%or bmordno like 2006% or bmordno like 2007%or bmordno like 2008% -billbody billheadselect transid from billheadwhere transid like 05%or transid like 06% or transid like 07%or transid like 08% delete from billheadwhere transid like 05%or transid like 06% or transid like 07%or transid like 08% delete from billbodywhere transid like 05%or transi