Solved

MSSQL restore finding the exact point in time that the recovered database backup was taken

  • 30 June 2022
  • 2 replies
  • 162 views

Badge

I have restored a copy of a Mssql database to a server via Comvault  how do i verify the point in time backup that was recovered by the Comvault process in the Comvault logs. This is for verification that correct database date\time was recovered . thanks in advance

icon

Best answer by Damian Andre 30 June 2022, 03:49

View original

2 replies

Userlevel 7
Badge +23

I think the best bet is to look at the browse.log on the CommServe, for that Job ID or take a look at fsindexedrestore.log on the Media Agent that performed the restore. I am not familiar with the mssql log to know if those details are printed there, but its worth a look.

Userlevel 6
Badge +15

@SSSDBA - Have you been able to find the information that you are looking for?  SQL restores are logged in SQLiDA.log on the SQL client.  You will find the information that you are looking for there.

Reply