• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Availability groups schedule sometimes skipped

bxtr97

ADSM.ORG Member
#1
I have an a SQL Availability Group. The backups are are working however i think i might have missed something in the setup as it is sometimes giving me the following message on the replica:

04/12/2019 08:03:01 ANS1814E Unable to start the scheduled event 'SQL_LOG_BACKUP_00'
04/12/2019 08:03:01 ANS1815E Either the window has elapsed or the schedule has been deleted

At the same time on the primary i get a message that the schedule ran but didn't backup the availability database because it was not the replica which i would expect

I have the sql scheduler service installed on both nodes in the group using the same TSM node. I have the sql settings to prefer the secondary replica for backups.

What i think is happening is that the schedule runs on the primary and completes with out doing anything so when the replica goes to run it sees that the backup for that scheduled time was already completed. If i just disable the service on primary the backups run on the replica everytime with no issue. But from my understanding i should be able to have the service running on both so the there is a failover the backups will run ont the secondary replica.

Any sugguestions would be appreciated.

Thanks
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 14 17.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 50 62.5%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.3%
  • Other (please comement)

    Votes: 7 8.8%

Forum statistics

Threads
31,378
Messages
133,647
Members
21,491
Latest member
OperatorJL
Top