How to change the path of a backup job to other location

• ALIF-662928

  SSCertifiable

  Points: 6054

  More actions

  April 15, 2008 at 8:16 pm

  #184441

  Hi i want to know how to change the path of some backups jobs to other location. Because the drive where the backups are going right has no free space so we want to change the backups path.How do we do that.

  I know one method, from where you can change the path, i.e from the management studio-->sql server agent-->jobs-->rightclick on job and select properties-->go to steps-->double click the step in the box-->Here change the location in the command box.

  Well i dont know will this method works properly or effects the schedules of backups, if we change the backup path.

  Please let me know what is the best way of doing this.

  Thanks

• N J

  Right there with Babe

  Points: 732

  More actions

  April 15, 2008 at 8:43 pm

  #802868

  Use your method if you are running backup command through job. It will not change schedule.