Skip to main content
Solved

how to extract the MSSQL LSN from the Commvault log


Forum|alt.badge.img+13

Hello Community

 

our DBA is requesting assistance in retrieving the MSSQL LSN number from the Commvault log.

For this MSSQL AG (Availability Group) backup, I accessed the active node during the backup process and examined the sqlida.log file. However, despite increasing the SQLIDA debug level to 10, the LSN information does not appear to be present in the log.

 

Just discovered that the LSN information can be found in the sqlbackup.log file only. However, I'm curious as to why certain SQL servers have both the sqlbackup module and the sqldia module, while others only have the sqldia module.

Best answer by Orazan

FR28 and above use SQLBackup.log and SQLRestore.log.  Jobs run prior to FR28 use SQLiDA.log

 

View original
Did this answer your question?

2 replies

Forum|alt.badge.img+15
  • Vaulter
  • 630 replies
  • Answer
  • July 11, 2023

FR28 and above use SQLBackup.log and SQLRestore.log.  Jobs run prior to FR28 use SQLiDA.log

 


Forum|alt.badge.img+13
  • Author
  • Byte
  • 104 replies
  • July 11, 2023

@Orazan thanks

if clients are in SP24 and how to get lsn info without upgrade to SP28
 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings