I found my Restore CD and was wondering if it was smart to use it.
That would not
be a smart idea
Most Restore CD's format the drive and restore the computer to the state it was in when delivered to you. This means that all your data is lost.
Your best bet for starters would be to use System Restore to restore your computer to a point in time prior to the deletion of the sound device. I cannot be sure that this will resolve the problem as only system files are restored, but give it a go.
Avantec Sound Rack Man
sound familiar - I guess you have an Avance AC97 onboard sound device.
As there are many drivers for that it would be helpful to know the make and model of your computer.
It would also be helpful if you could provide the information derived from here ....
Right click My Computer icon > Properties > Hardware > Device Manager and scroll down (if necessary) to Sound, Video and Game Controllers, expand that section by clicking on the + sign. What do you see there - any yellow exclamation marks? Please post a list - see screenshot below of Device Manager.