Enabling backup plan

  • i have to backup plans, as per advice one i have disabled, due to some reason i wanted to enable the same, so in management plan i enabled the earlier disabled plan but backup is not happening.

  • Every maintenance plan created will have a corresponding entry in the sysjobs tables in msdb database. Hence cross check if the enabled option is set to '1' using the following TSQL statement.

    use msdb

    select * from sysjobs

    Also check for the origianting serverid column in the above query. Sometimes if the scripts are copied from some other server, then the originating server id needs to be changed to the current server. This could also be one of the reason.

    Also to cross check if the created plan is working fine kick of the backup plan manually and monitor the progress.

    -Rajini

  • management plan i enabled the earlier disabled plan

    Enabled the schedule as well.

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

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