创建SSIS包进行备份并在两个SQL SERVER之间恢复它吗? [英] Create SSIS package for backup and restore it across two SQL SERVER?

问题描述

我是SSIS的新手.任何人都可以指导我如何创建SSIS包并每周计划一次.可以在SERVER A上生成备份文件并将其还原到SERVERB.

请返回富有成果的建议！

I am new for SSIS..can anyone guide me how to create SSIS package and schedule it once in a week. which can generate backup file on SERVER A and restore it into SERVER B.

Please revert with fruitful suggestion!!

推荐答案

在这里，看看:

Here, have a look: Automate Database Restore to Remote Instance with SSIS[^]

这篇关于创建SSIS包进行备份并在两个SQL SERVER之间恢复它吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！