While using SQL 6.5 my company adopted the practice of Rebooting the SQL Server once a week. When we upgraded to 7.0 we kept the reboot schedule for a while but now have moved away from it. Is there any reason that the SQL DB should be restarted?
No - just the usual adminstrative reasons - service packs, hot fixes ... and of course the emergency situations. There have been cases of memory leaks and 100% cpu usuage but if you keep up with service packs you will be ok.