2

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:

  1. This question has been asked here and here in slightly different context but with no solutions.
  2. Also, the question is 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)
  3. So please answer the question only if you know a solution and/or have tested if before.

enter image description here

Tab Alleman
  • 31,483
  • 7
  • 36
  • 52
nam
  • 21,967
  • 37
  • 158
  • 332

1 Answers1

1

Go to the Management -> Maintenance Plans -> Backup Databases instead of SQL Server Agent -> Job Activity Monitor.

enter image description here

Brian
  • 6,717
  • 2
  • 23
  • 31
  • @Brain I went to `Management -> Maintenance Plans -> Backup Databases` and did not see the screen you're showing. I'm using SQL server 2012. And please note, as I mentioned in my post, this is the plan I created using `Maintenance Plan Wizard` – nam Jun 06 '18 at 20:12