SQL maintenance plan on Primary and secondary server RRS feed

  • Question

  • We have setup Hi Availability group on SQL 2012.

    As usual i have created backup maintenance plan in Primary and secondary server with 2 tasks i.e

    • Backup maintenance Task
    • Maintenance cleanup task

    Then i have created Job and selected given maintenance plan.

    After many days when i again looked up, i saw that jobs are failing from many days on these servers. sometimes it says about file not found with xp_delete_file().

    I am not sure whether continuing backup strategy as i was doing in  SQL2008 is right way or not when working with High Availability group

    One thing which i noticed is that backup is running fine when it became secondary server, but i still need to confirm that.

    Any suggestions/views

    Technical User

    Tuesday, April 14, 2015 2:47 PM


All replies