• igorg (1/21/2009)


    I agree with Warren. In MSDN its clearly written that msdb.restorehistory contains one row for each restore operation.

    For VERIFYONLY restore option column [restore_type] will contain 'V'

    V = Verifyonly

    RESTORE VERIFYONLY can write to history system table if you specify LOADHISTORY option. The question doesn't mention this at all, so the answer is No.


    Urbis, an urban transformation company