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

creating a report on restores

I have scripted out the restore of a couple of thousand databases and it seems to work fine. But I need to be able to generate a report on any failures so I do not have to dig through the output. The built in reporting seems to only be for backups. Is it possible to generate a report on restores out of Red Gate's logs? Is this a built in feature that I have just missed? Thanks for your help.
mherfkens
0

Comments

3 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    You haven't missed a feature, the report facility only shows you backup history. It's a good suggestion to add restore data to this report, so I've logged a feature request for it (SB-4562).

    Currently, the best way to view the restore history will be to view the activity history within the GUI.
    Chris Auckland
    0
  • mherfkens
    Chris,

    Thanks for the reply. I have been using the activity history, I was just looking for something a little more flexible and easier to read. Unfortunately when you are looking through that many restores using the activity history is cumbersome.

    Michael
    mherfkens
    0
  • brosato
    I use the With Mailto option. I set up a filter in Outlook to move all success emails to a folder and only leave failures in my inbox. Works pretty well.
    brosato
    0

Add comment

Please sign in to leave a comment.