May be this database point to D:\ drive.

1. please look in to data files first.

2. if its point to D:\ change to E:\ drive.

then run the restore script