确保SQL代理服务处于启用状态
![](https://wkrtcs.bdimg.com/rtcs/image?w=254.42&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"254.42","h":"492.84","dataType":"png","c":"word/media/image1.png","imgOriW":318,"imgOriH":616})
如果未启用，右键→启用
维护计划→右键→维护计划向导
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"433.00","dataType":"png","c":"word/media/image2.png","imgOriW":825,"imgOriH":645})
初始窗口默认下一步
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"436.93","dataType":"png","c":"word/media/image3.png","imgOriW":815,"imgOriH":643})
建立计划名称
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"437.20","dataType":"png","c":"word/media/image4.png","imgOriW":817,"imgOriH":645})
选择你需要计划为你做什么事，我们是对OA进行完整备份，所以选择备份数据库(完整)
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"434.47","dataType":"png","c":"word/media/image5.png","imgOriW":817,"imgOriH":641})
确认计划内容的执行顺序，我们只让维护计划做一件事所以不用调整执行顺序
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"499.67","dataType":"png","c":"word/media/image6.png","imgOriW":849,"imgOriH":766})
这一步需要指定执行计划对应的数据库，选中OA的数据库
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"693.87","dataType":"png","c":"word/media/image7.png","imgOriW":815,"imgOriH":1021})
这一栏选择备份的方式和备份文件的位置
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"434.27","dataType":"png","c":"word/media/image8.png","imgOriW":820,"imgOriH":643})
这一步设置日志报告的保存位置
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"436.53","dataType":"png","c":"word/media/image9.png","imgOriW":817,"imgOriH":644})
维护计划向导完成
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"430.73","dataType":"png","c":"word/media/image10.png","imgOriW":828,"imgOriH":644})
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"228.47","dataType":"png","c":"word/media/image11.png","imgOriW":1556,"imgOriH":642})
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"206.07","dataType":"png","c":"word/media/image12.png","imgOriW":1239,"imgOriH":461})
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"420.47","dataType":"png","c":"word/media/image13.png","imgOriW":1109,"imgOriH":842})
设置备份时间和备份的重复方式
维护计划→计划名称→右键→执行
弹出执行窗口。显示成功即可
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.80&md5sum=ef563050631feecda8ed3ebffda38bf2&sign=6e37273ce3&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=79&ipr={"t":"img","r":"r_2","w":"553.80","h":"284.67","dataType":"png","c":"word/media/image14.png","imgOriW":823,"imgOriH":423})
本文来源：https://www.2haoxitong.net/k/doc/07476d769a6648d7c1c708a1284ac850ad0204f8.html
文档为doc格式