本文适用于InventoryControl v4或v5。对于版本6和7,请参阅下面的相关内容。
下载并提取http://dl.waspbarcode.com/kb/ic/v5/BackupDB4IC.zip在服务器上执行BackupDB4IC.bat命令,在C:\Program Files\Microsoft SQL server \MSSQL.1\MSSQL\ backup \下创建备份文件。文件名将是MIBackup_
如果需要更改路径或文件名,请编辑“BackupDB4IC”。wql用记事本更改行开始设置@FileName。如果要更改文件路径,则必须将其定向到服务器上已经存在的本地文件夹,否则脚本将失败。
要调度此进程自动运行,您可以使用Windows任务调度程序,如下所示:
Windows 7:启动>所有程序>附件>系统工具>任务调度程序它可能会花几秒钟的时间向管理控制台添加一个管理单元,然后它就会打开。在右侧的“操作”窗格中,选择“创建基本任务”。为任务提供一个名称,比如WaspBackup,然后单击Next。选择您希望流程从列表中运行的频率,然后单击Next以输入详细信息。根据您的选择频率,系统将提示您输入每周或每月的日期和运行流程的时间。在下一页上,它将询问您希望它执行什么操作。点击“启动程序”单选按钮,然后点击“下一步”,然后浏览。定位BackupDB4IC。bat,选择它并单击Open,然后单击Next。 If you check the box for "Open the Properties dialog for this task when I click Finish", it will open an interface with many additional conditions for the task. This is where you can specify a different user for the task to run as, as well as options for whether to run when the user is logged in only, or whether the user is logged in or not. It does default to only when the user is logged in. Also, on the Settings tab, there are boxes for "Run task as soon as possible after a scheduled start is missed" and "If the task fails, restart every:", which you should look at. This Properties window is the same as what opens if you initially choose Create Task rather than Create Basic Task, so you may start here, but the initial rule creation may be easier in Basic Task. To see the task, click Task Scheduler Library at the top left. Click on the task in the top center pane, and the Properties will be shown in the bottom center pane for verification. If you need to change any of the settings, you will need to right click the task and select Properties.
Windows XP操作系统:依次启动>所有程序>附件>系统工具>定时任务。双击“添加定时任务”。单击欢迎消息上的Next,然后浏览。找到BackupDB4IC.bat文件并选择它。选择您希望流程从列表中运行的频率,然后单击Next以输入详细信息。根据您的选择频率,系统将提示您输入每周或每月的日期和运行流程的时间。然后将提示您输入Windows用户的用户名和密码,任务将作为该用户运行。您应该输入一个在Windows中有足够权限运行bat文件并写入指定目录的用户。如果您选择打开任务的高级属性,您将能够指定一些额外的事情,如是否在计算机使用电池供电时运行任务,等等。通常默认设置就可以了。 The task will now be shown in the Scheduled Tasks window, should you wish to check/change the properties or verify the status of when it will run, when it last run, and whether it failed when last attempted.