Hi.

 

Recently we are having to restore our Support Centre database every few days as it stops responding and this is the only way to fix it, even if we reboot the server, restart the services, etc.  Therefore my assumption is that the database is corrupting.

 

The symptoms of this are simply that there is no response from the server, it just times out when users request the page through a browser.  I manually use run.bat on the server and this shows that the server is running, but it just doesn't resopnd to requests.  I've looked in the logs and see nothing that helps, as with the Windows Event Logs.

 

We are running Support Centre build 7609 on a Windows 2008 R2 server with Microsoft SQL 2008 R2.

 

Any suggestions for fixing this would be welcome as it's becoming a nightmare to manage.

 

Thanks,

Dave