Unfortunately some tables are completely deleted with important data. The database is hosted on azure, but there is no back up for past 1 month as well.
Is there any way I can get the lost data?
The database is azure SQL v 11.
Asked
Active
Viewed 99 times
0
1 Answers
3
You may actually be able to do a restore. Grant Fritchey talked about it here.
Basically if you go to the portal and look at the screen for the database there is a restore option. Once you select it it will give you the oldest restore point available. You can't overwrite your database but you can restore it to an alternate location. It looks like you can only do this threw the GUI. Once you have your alternate location restored you can get your data.
Since you can't do cross database queries you may have to find a third party software or download the data then upload it into the correct DB.
(There was something about being able to do cross database queries if you are in an elastic pool but I've never done that myself.)
Kenneth Fisher
- 24,307
- 13
- 63
- 116