Reputation: 23819
I've already created a backup plan in SQL Server 2012
using their Maintenance Plan Wizard
. This plans runs every midnight and stores the backups at the default location C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup
. But, after one year, now I want to change it's destination folder where the backups are stored. But I can't find any place where I can make that change. So, I went to its job menu
where in the Steps
window I only see the following command. Question: Is there any way we can change the destination folder? If not, in the command window shown below, how can I change the syntax so it store the backup to, say, D:/myNewFolder
NOTE:
NOT
about changing the default SQL Server backup folder in general (as has been asked here). My question is specific to changing the backup folder in my only one backup plan created using Maintenance Plan Wizard)Upvotes: 2
Views: 4738
Reputation: 7289
Go to the Management -> Maintenance Plans -> Backup Databases
instead of SQL Server Agent -> Job Activity Monitor
.
Upvotes: 1