Which operating system? Windows 7 has some sleep problems, apparently MS are working on fixes for these.
Is it going into sleep mode while the ASIO driver or Cubase is running? ASIO/Cubase do not like being powered down, it's probably best to close these programs if the computer's going to power down for a while.
Although if you're only running on mains power, why use sleep mode at all? I'd just go into Control Panel > Power Options and disable sleep/hibernate altogether!