I've an issue with SQL2008 Server that gobbles up memory over time and never releases it back to the OS.
I've set memory restrictions on it and many, many other settings over the last few weeks to no avail.
I figure it's some sort of memory leak (since we had a similarly configured SQL2005 and never had this issue before - so the queries/indexes/client do not appear to have any problems).
Regardless, I wanted to restart SQL2008 every 24 hrs automatically (from Task Scheduler, preferably).
Not sure how to go about this. I can't seem to find any way from the BOL (not really sure what to look for)