Một công cụ quy tắc thích hợp khi ứng dụng của bạn liên quan đến việc ra quyết định quan trọng, các quy tắc phức tạp hoặc thay đổi thường xuyên, các quy tắc cần phải được chia sẻ trên nhiều ứng dụng và các tổ chức, hoặc bạn đang ở trong một ngành công nghiệp ổn định mà thay đổi có tiêu chuẩn hoặc quy định là mở rộng và phức tạp. | CHAPTER 9 BIZTALK SERVER 2006 OPERATIONS 339 Rule Engine BizTalkRuleEngineDb BAM Primary Import BAMPrimaryImport Trading Partner Management TPM HWS Administration BizTalkHWSDb BizTalk EDI BizTalkEDIdb These databases must be backed up by the Backup BizTalk Server SQL Agent job and cannot be backed up using the normal SQL Server backup procedures. The reason is because BizTalk uses SQL Server log marks to keep the set of databases consistent as part of DTC transactions. The Backup BizTalk Server job creates a log mark and then backs up the database log for each database that is part of the Backup BizTalk Server SQL Agent job. This log mark is used when restoring the last log file for each database so that transactional consistency is maintained. Here are the steps to configure the Backup BizTalk Server SQL Agent job 1. In SQL Server 2000 Enterprise Manager or SQL Server 2005 Management Studio navigate to the SQL Agent jobs list. 2. Right-click Backup BizTalk Server BizTalkMqmtDb and select Properties. 3. In the Job Properties dialog under Select a page click Steps to view the job steps. 4. In the Job step list click BackupFull and then click Edit. 5. On the General page in the Command box replace destination path with the full path the path must include the single quotes to the computer and folder where you want to back up the BizTalk Server databases. Also add a new parameter by typing a comma and then a number one 1 at the end of the parameter list for the stored procedure sp_BackupAllFull. Adding this parameter enables an automatic full backup after a backup failure. Click OK when finished. Note The default frequency for the BackupFull job is d for daily. Other values are hourly h H weekly w W monthly m M or yearly y Y . The first time the job is run during a new period a full backup is performed. Also the default name is BTS which will be part of the backup file name. Change this to reflect a better name for the application such as OrdSys for an application .