Get list of all restore points of databases from sql management instance

Breno Padovan 21 Reputation points

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,009 questions
{count} votes

2 additional answers

Sort by: Most helpful
  1. Bruce ( 44,646 Reputation points

    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.

    0 comments No comments

  2. Olaf Helper 34,291 Reputation points

    If you mean the restore actions have been taken, then you get it from system dtabase "msdb", see

    restorehistory (Transact-SQL)

    0 comments No comments