Share via

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

Breno Padovan 21 Reputation points
2023-09-14T19:17:04.0566667+00:00

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.
13,670 questions
Accepted answer
  1. ZoeHui-MSFT 36,116 Reputation points
    2023-09-15T05:54:40.34+00:00

    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.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 64,161 Reputation points
    2023-09-14T19:33:46.3433333+00:00

    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
  2. Olaf Helper 44,296 Reputation points
    2023-09-15T05:30:26.36+00:00

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

    restorehistory (Transact-SQL)

    0 comments

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.