On the Support website for your Handycam, you can download Sony's "Memory Card File Rescue" software. This is designed to recover accidentally erased data: -
Just to clarify, the software suggested by Blencogo is also the one that I would also recommend. There may be other products available online but I would always start with the product offered by Sony.