nam
nam

Reputation: 23819

Change destination folder in SQL Server Database backup plan

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

Upvotes: 2

Views: 4738

Answers (1)

Brian
Brian

Reputation: 7289

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

enter image description here

Upvotes: 1

Related Questions