Share via

I accidentally started restoring a two-week old SQL backup onto live Azure database instead of test database

Bob Kiefer 21 Reputation points
2025-05-16T03:09:05.93+00:00

I have an urgent need for server/database support - I accidentally started restoring a two-week old SQL backup onto live database instead of test database

Most of the important tables have been wiped out.

Thank you,

Bob Kiefer

(203) 685-7104

******@scsdirectinc.com

Azure SQL Database
Accepted answer
  1. Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator
    2025-05-16T11:57:35.61+00:00

    Hi @ Bob Kiefer

    As discussed during our remote session, It looks like the issue you're experiencing is due to your current live database being override by 2 weeks old backup files. As a result, the most recent version of your database was lost. To help resolve this, I recommended checking for the latest available backups in the Azure portal. You were able to locate and restore the most recent backup file, which should bring your database back to its original state.

    Your feedback is valuable to us—please take a moment to click "Accept Answer" and "Yes" if you found the response helpful.

    If you have any further questions or need additional assistance, feel free to reach out. We're always happy to help.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.