Re-Import Backup Information

DanAppleyard

I have a situation where the msdb.dbo.backupset table had a typo in the database_name field for some of the records.  This caused SQL Monitor to display backup information incorrectly.  After correcting the backupset table, is there a way to have SQL monitor re-import the data from backupset and display the information correctly?  The query SQL Monitor seems to run to get that information has a datetime filter in the query (most likely to just get any new information since it last ran).  Is there a way to get around that?

Russell D

Not into the Monitor UI no I'm afraid. You could run the query manually and export the data to CSV as a potential workaround? Its not ideal I know.