Azure SQL Datbase restoring

Question

Azure SQL Datbase restoring

henrik johansen 0

Yesterday i managed to delete the wrong database but noticed sql server Azure had this deleted database function. ive restored the database 1 hour ago and can see that the tables have come back but no data has been restored in the tables. does that process take a long time or does it not restore the data ?

Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-06T11:34:06.8533333+00:00

Hello henrik johansen

I kindly request you to please share the details requested in the private message, which will help us to investigate
Balmukund 176 Reputation points Microsoft Employee

2025-06-08T01:28:44.5033333+00:00

The restore process doesn't touch the data inside the database. It would bring the database back to the time when the backup was created. As Saraswathi mentioned, you may want to share the details which can help her in digging at telemetry. Also share the exact steps to make sure we are not missing anything.
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-09T05:36:03.0166667+00:00

Hello henrik johansen

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-06T11:34:06.8533333+00:00

Hello henrik johansen

I kindly request you to please share the details requested in the private message, which will help us to investigate
Balmukund 176 Reputation points Microsoft Employee

2025-06-08T01:28:44.5033333+00:00

The restore process doesn't touch the data inside the database. It would bring the database back to the time when the backup was created. As Saraswathi mentioned, you may want to share the details which can help her in digging at telemetry. Also share the exact steps to make sure we are not missing anything.
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-09T05:36:03.0166667+00:00

Hello henrik johansen

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hello henrik johansen

Restoring a deleted Azure SQL Database should bring back both schema and data as it recovers from a point-in-time backup

Did you restore from the correct point in time?

If you restore the data from backup where initially the data was deleted, the restore will include the schema but not the data.

Check Activity Log in Azure:

Go to your SQL server in Azure >> Click Activity Log
Filter by "Restore" operations.
Confirm the restore was "Succeeded" and not partially failed.

Ensure the database is not in a read-only or recovery state that might affect visibility.

Currently T-SQL is the only supported way to view accurate progress of a backup restore operation and there is no support via Portal, PowerShell, CLI or API.

Here is a sample T-SQL query to view the status of a Restore operation:


Select * from sys.dm_operation_status 

where operation like '%Restore%' 

order by Start_Time Desc;

This DMV contains a column called percent_complete which displays 3 states:

0 = Operation not started
50 = Operation in progress
100 = Operation complete

Please review the scenarios mentioned above. If the issue still persists, feel free to reach out with the requested details so we can assist you further.

PratikLad 1,825 Reputation points Microsoft External Staff Moderator

2025-06-11T16:27:36.25+00:00

Hello henrik johansen,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
PratikLad 1,825 Reputation points Microsoft External Staff Moderator

2025-06-12T14:42:39.99+00:00

Hello henrik johansen,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Azure SQL Datbase restoring

1 answer

Your answer