We have a USB external hard drive attached to a Windows 2003 Server. This drive was attached to accommodate backups of our SQL server databases because we simply were running out of room. The problem is that every time the server is restarted, which is done automagically every Wednesday and Sunday, the drive does not come back unless it is unplugged from the USB port and plugged back in.
This is a somewhat older server, so we had to add a PCI USB 2.0 card to accommodate this drive. The drivers for this card are current as are the drivers for the external hard drive.
Does any one have a suggestion as to how we can prevent this or possibly a script that will force it to be recognized without someone having to physically unplug then plug the device back in after the restart is complete?