ProgramGood.Net - MSDE http://www.programgood.net/ The journey to becoming a great programmer en-us Dave Mateer Fri, 13 Apr 2012 09:44:49 GMT newtelligence dasBlog 2.2.8279.16125 davemateer@gmail.com davemateer@gmail.com http://www.programgood.net/Trackback.aspx?guid=bd6c1258-c0af-43b1-971a-b5b5c6e29576 http://www.programgood.net/pingback.aspx http://www.programgood.net/PermaLink,guid,bd6c1258-c0af-43b1-971a-b5b5c6e29576.aspx Dave Mateer

As MSDE seems to have a memory leak I simply restart it every week.

c:\restartmsde.bat

@ECHO OFF
NET STOP MSSQLSERVER
NET START MSSQLSERVER

Scheduled task to run as Administrator every Sunday at 2:30AM NZT

Restart MSDE Scheduled Task http://www.programgood.net/PermaLink,guid,bd6c1258-c0af-43b1-971a-b5b5c6e29576.aspx http://www.programgood.net/2012/04/13/RestartMSDEScheduledTask.aspx Fri, 13 Apr 2012 09:44:49 GMT <p> As MSDE seems to have a memory leak I simply restart it every week. </p> <p> c:\restartmsde.bat </p> <p> @ECHO OFF <br /> NET STOP MSSQLSERVER <br /> NET START MSSQLSERVER </p> <p> Scheduled task to run as Administrator every Sunday at 2:30AM NZT </p> <img width="0" height="0" src="http://www.programgood.net/aggbug.ashx?id=bd6c1258-c0af-43b1-971a-b5b5c6e29576" /> MSDE