Post reply

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

  • April 15, 2008 at 8:16 pm

    #128615

    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

  • April 15, 2008 at 8:58 pm

    #802870

    You can definitely setup different backup locations for different databases. if you are using a maintenance plan to backup the databases, you can setup multiple maintenance plans. If the jobs that you have setup are manually scripted then also it should be very straightforward. Can you share what your job looks like? Can you post the script?

    Thanks

  • April 16, 2008 at 9:04 am

    #803142

    you should create the maintplan, and this creates the SQLAgent job(s)

    if you start fooling with the job, the maintplan and job may differ and can get you into trouble

    - so just change the maintplan and never the worker job(s)

    BTW

    1. there was a bug with the SS2005 RTM that any edit of the maintplan reverted the backup path to default .\backup path, and this was eventually fixed by SP2

    2. dump files (*.BAK) tend to fragment a disk volume so is recommended to keep away from db itself (*.MDF, *.LDF)

    3. don't even think of setting NTFS folder compression on .\backups folder unless done #2 !

    HTH

    Dick

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply