Post reply

SQL server maintenance plan - change target location of backup job

  • September 2, 2009 at 11:27 pm

    #209579

    Hi,

    I need to change the target location of a backup job scheduled previously from maintenance plan.

    Please let me know how this can be done?

    Thanks,

    Keerthi

  • September 3, 2009 at 12:33 am

    #1048541

    I haven't tried this but if you have a maintenance plan then i suppose you can modify the plan. If you have a T-sql statements put in a job you can modify the statements.

    "Keep Trying"

  • September 3, 2009 at 2:23 am

    #1048571

    DBAsql (9/2/2009)

    Hi,

    I need to change the target location of a backup job scheduled previously from maintenance plan.

    Please let me know how this can be done?

    Thanks,

    Keerthi

    go into the maintenance plan and change the backup directory.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

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