Well thats my pleasure..Iam glad my post could be of help!!..

regards

Santosh Vishal Adiraju.,

Yes..firstly we need to find the root cause..

Identifying why the restore has failed- check the last copied file that has been restored in the tables(using msdb queries)..

1) ..see the number..if...