如何更改 sql server 代理中的备份路径

问题描述:

我想更改我的 sql server 2008 r2 备份位置,我正在使用 sql server 代理做备份工作,现在驱动器已满我想备份到其他驱动器.请告诉我如何解决的步骤这个问题

i want to change my backup location of sql server 2008 r2 ,i am using sql server agent to do backup job ,now the drive is full i want to make the backup into other drive.please provide me the steps how to resolve this issue

转到管理>维护计划> 然后从属性窗口中选择计划并更改目标自动文件夹路径

Go to Management>Maintenance Plan> Then select the plan and change the destination auto folder path from the property window