Iggy (1/21/2009)

---

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.