• Steven Cameron (1/21/2009)


    I got the question wrong, but after searching some more found out I WAS wrong. It would put the information into the restorehistory table if you used the LOADHISTORY option. which wasn't used in the question.

    http://msdn.microsoft.com/en-us/library/ms178615.aspx

    Interesting. I missed that option when I read it the first time.

    It's sometimes handy to see restores in that table just to see who did what and when. But I wonder what use there would be for keeping a record of restore verifyonly executions?

    The only think I can think of is a senior DBA checking up on a jr. dba making sure they run restore verifyonly before running the real restore? But even that seems like a stretch.

    The Redneck DBA