一个设想
<P><FONT face="verdana, arial, helvetica" size=2>本人所在的企业是一家连锁超市,有七，八家门店将要用光纤时时联网形成一个大型局域网，每台门店设一台服务器(win2000sp4,sybaseforwin12.5)及收银终端,各门店服务器在同一网段内。<BR>设想如下：<BR>在各门店服务器编写如下批处理dump_no1(1号门店）dump_no2(2号门店).............,设定计划任务每晚02点执行.<BR>cd c:\<BR>isql -Usa -P -i dump.txt -o g:\no1\dump.txt<BR>isql -Usa -P -i check.txt -o g:\no1\lcheck.txt<BR>go<BR>其中g:\为在同网段内的一台PC机的共享目录(24小时开机)<BR><BR><BR>dump.txt内容如下：<BR>use userdbname<BR>dbcc checktable (syslogs)<BR>dump transaction userdbname with truncate_only <BR>dump database userdbname to 'f:\backup\userdbname_bak'<BR>go<BR><BR>check.txt内容如下：<BR>sp_freedisk<BR>go<BR><BR><BR>其中：sp_freedisk列出SQL server中所有设备的逻辑名，物理设备名，设备号，设备大小，已经使用的设备空间，剩余设备空间。 <BR><BR>use master <BR>go <BR>create proc sp_freedisk <BR>as <BR>set nocount on <BR>select <BR>logical_name = substring(d.name,1,12), <BR>physical_name = substring(d.phyname,1,17), <BR>vdevno = d.low/power(2,24), <BR>size = (d.high- d.low+1)/512, <BR>reserved = isnull(sum(u.size)/512,0), <BR>left = (d.high-d.low+1)/512 - isnull(sum(u.size)/512,0) <BR>from <BR>master.dbo.sysdevices d, master.dbo.sysusages u <BR>where <BR>d.status & 2 =2 <BR>and <BR>u.vstart/power(2,24) = d.low/power(2,24) <BR>group by <BR>substring(d.name,1,12), <BR>substring(d.phyname,1,17), <BR>d.low/power(2,24), <BR>(d.high-d.low+1)/512 <BR>order by <BR>vdevno <BR>go <BR>grant execute on sp_freedisk to public <BR>go <BR><BR><BR>这样一来,我每天是不是只要打开含有共享目录g:\的电脑,查看no1(1号门店),no2(2号门店)目录下的dump.txt及check.txt,就能查看和门店服务器上数据备份情况及数据设备使用情况及对于日志清除等相关信息了.<BR>以上设想可否实现,有没有问题,希望各们同行给以指教,谢谢!</FONT></P> 好象不错的想法~~试一下啊~~
页:
[1]