If I understand this correctly, the HDD partition table was found to have disappeared after maintenance. Only later was the faulty SSD connector discovered. The SSD was probably used as L2. To me it seems this has nothing to do with Primocache so it is unlikely that Romex can help you.
I've seen many computers dropping disk partition tables. Cause unknown but in one clear case (older ASUS mobo) I have proof that the BIOS is buggy and randomly zaps the partition table. If this is the case, it can be repaired without data loss.
Download the Aomei Partition Assistant (freeware, works great for me) from
http://www.disk-partition.com/download-home.html and install it on you boot disk (not on the faulty one).
- From the Aomei Wizard menu, select Partition Recovery Wizard. Highlight (single left-click) the disk you want to repair and click Next.
- Select Fast search. If it finds no partitions, try Full search. If Full search finds nothing: panic.
- After scanning it will show a list of the partitions it found. Some may be ghosts so try to guess which ones you need to recover and select those.
- Click Proceed and the selected partitions will be instantly recovered. It does so by rebuilding the partition table.
I found that recovering one partition at a time gives better and faster results. Start by recovering the first partition and repeat the same procedure until you have all lost partitions back.
Run a full chkdsk /f on all recovered partitions. Afterwards you can use Primocache to re-assign the SSD to L2 cache for the HDD.
Should Aomei fail, use Google to find other repair tools. In essence they all do the same thing: scan an rebuild the partition table.
To prevent further mishaps you can download a terrific free-for-personal-use image backup tool from
http://www.macrium.com/reflectfree.aspx. Macrium Reflect allows you to backup/restore a complete image of a disk to/from a backup medium. It also allows you to burn a bootable rescue CD. It saved my ass numerous times.
Good luck and let us know how things work out.