如何查看DB是否加入备份计划？

Question

各位大侠：

怎么样查看哪些DB已加入数据库维护（备份）计划？如果一个DB有设置数据库备份计划，可以从哪里看的到呢？

谢谢。

---

Thanks, Yoyo Yu

Answer 1

Have to check maintenance plan.

Answer 2

我就是想写一个JOB，中间要调用那些已设定维护计划的DB名称，所以想通过一些表来查看，不知道有没有这些表？ 谢谢

---

Thanks, Yoyo Yu

Answer 3

没有

维护计划也是通过Job来完成的,你可在agent里找到维护计划相关的job.  你可以尝试解析列面的语句来确定是否有备份,但比较麻烦吧...

 

---

有dba的职位吗(北京的)，请联系我 stswordman#hotmail.com

Answer 4

It runs as ssis package, can't find any statement in the job because package is encrypted. Therefore you don't know which db is included in the plan without looking at the plan itself.