How can we help you today? How can we help you today?

Re-Import Backup Information

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?
DanAppleyard
0

Comments

1 comment

Sort by
  • 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.
    Russell D
    0

Add comment

Please sign in to leave a comment.