Build Restore History table
What about using the tables already in the MSDB database, Restorehistory, BackupSet and BackupMediaFamily?

These databases will already have all of the backup and restore history. I would check though that in your particular case what the behaviour looks like in the Restorehistory table. You should be able to check in these tables that after your restore process whether it was successful or not and provoke the appropriate action you want. 

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