sqlbackupazure-sql-databasesql-azure-alerts

SQL Azure automated backup fails on a DB which has been deleted - cannot remove backup task


UPDATE: I was able to contact the SQL Azure team and they are prioritizing the bug. Hoping for a solution soon and will update here when I hear back.

While testing the new automated Export function in SQL Azure, I set a test database to backup nightly. When this test was complete, I deleted the test database, but the automated export task still attempts to run nightly and floods my team with emails regarding the failure of this orphaned database. Is there any way to delete the export job, or perhaps at least suppress the bogus alert?

How to repro:

  1. Create a blank SQL Azure DB
  2. Turn on automatic export.
  3. Wait 48 hours to see a couple of exports successfully occur
  4. Delete the test database created in step 1

Desired result: Export task is deleted/disabled and does not attempt to make an export nightly. No alert emails are sent.

Actual Result: Export task on the deleted database is attempted nightly and a failure email is sent to my team nightly.


Solution

  • Response from SQL Azure team:

    Hello,

    We have investigated the issue and should have a fix soon. In the meantime I would recommend creating a filter for these emails. Once the fix is rolled out you can remove the filter (I will respond back to this thread once it is).

    If you do not want to receive any failure emails you can opt-out permanently via the Unsubscribe link at the bottom of the email. Note, however, that this is permanent and will apply to all export failure emails: once you have opted out there is no way to opt back in later.

    Apologies for the inconvenience, -Stephen