This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 94%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Hey guys,
Is it possible to get a list of all restore points for a given database in the SQL management instance?
Best regards,
Breno Padovan
With "sql management isntance" do you mean Azure SQL Managed Instance? Or something else.
Hi @Breno Padovan,
Check it out here to see if you mean like this.
Restore Points - List By Database
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
it depends. SQL management just queries the backup logging tables in msdb. assuming the history tables have not been purged (sp_delete_backuphistory), then it's accurate of all backups done on that server. you could query the tables yourself. if the history table has been purged, you can open the actual backup set to get information.
a restore to point requires none of the required backup files have been deleted.
If you mean the restore actions have been taken, then you get it from system dtabase "msdb", see