Post reply

Enabling backup plan

  • August 7, 2008 at 11:53 pm

    #190741

    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.

  • August 8, 2008 at 2:56 am

    #854979

    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

  • August 8, 2008 at 7:57 am

    #855188

    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