locked
Maintaince jobs failing RRS feed

  • Question

  • Hi Team,

    We are configured Mirroring & Logshipping in 3 servers 01-02 is mirroirng and 01-03 Logshipping

    in 01 we have taken  01 server cloning the same in 02 & 03 also

     01 is Principal server here we have maintaince jobs here its working succesffully

    in 03 also the same maintaince plans is there here some of sub plans are failing due to some reason

    My Question is :

    In Maintaince plan we have some backups full, -t-log, Re-build index etc..

    in full and T-logs backups are  failing every day.

    The same data is only in 03 also why we need Maintaince plan in 03 ?

    because in 01 mirroing,logshipping and full & T-log backups are going to good.

    Can you please suggest in 03 server what action we have to take can i remove the maintaince backups or it will continue please suggest me.

    Thanks


    subu

    Tuesday, July 31, 2012 9:55 AM

All replies

  • Hi Subbu,

    There is no need to have backup job on the 03 Server, because

    01----principle server

    02----mirrored Server

    03----Standby server for log shipping

    in log shipping standby server databases will be in standby/norecovery mode,we can't take the backup of the database which is in standby/norecovery mode,


    Ramesh Babu Vavilla MCTS,MSBI

    Tuesday, July 31, 2012 10:16 AM
  • yes babu you correct

    In maintaince paln i m also getting the same error

    Database was in stand by mode.


    subu

    Tuesday, July 31, 2012 10:29 AM
  • delete the maintenance job on the 03 Server,

    please make sure there are few jobs which runs for log shipping in the standby server  like

    LS_Copy_dbamae

    LS_Restore_dbname

    alerts are the jobs

    there 3 jobs are used for log shipping,

    other than  these 3 jobs you can delete the rest of the maintenance plans used to take backup can be deleted


    Ramesh Babu Vavilla MCTS,MSBI

    Tuesday, July 31, 2012 11:52 AM