Re: MSDE - Just Stops!

Hi,

Verify the SQL Server Logs as well for any errors. It is always recommented
to check the logs atleast once a day.

Check if there is any memory leak 3rd paqrt programs in ur server.

Thanks
Hari
SQL Server MVP

"Fred Nelson" <fred@xxxxxxxxxxxxxx> wrote in message
news:umZDRJNUFHA.2664@xxxxxxxxxxxxxxxxxxxxxxx
> Hi:
>
> I have a Win2000 server that has been running MSDE for about five months.
> Suddenly today it just stopped running.
>
> There were no entries in the event viewer or anything. I stopped and
> restarted the service and it still did not respond.
>
> Finally I rebooted the computer and it's working once again. I rebooted
the
> machine last night so it had only been running about 12 hours and was
> functional this morning.
>
> Does anyone have any suggestions on how to determine what happened - and
> prevent it from happening in the future?
>
> Thanks for your help!
>
> Fred
>
>


.

Relevant Pages

  • Re: Logging
    ... > Is there a way to extract information from the SQL Server logs about ... > procedure calls, triggers, etc. after they run? ... Check out SQL Server profiler, you can capture traces, even play them back. ...
    (microsoft.public.sqlserver.connect)
  • Re: Network login problem
    ... Please explain why the events is logged in the SQL server logs if remote connections is not enabled. ... login locally. ...
    (microsoft.public.sqlserver.connect)
  • viewing logs on clustered sql server
    ... anyone had a problem where on a clustered sql server, ... from within enterprise manager> management> sql server logs ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL2K OLAP Stopping
    ... In my case, when some part of FAT related to Data folder was broken long time ago, ... What buffles us is that after checking the event logs and SQL Server logs, there is no indication that it did stop. ...
    (microsoft.public.sqlserver.olap)
  • Re: scheduled jobs not running
    ... Make sure the schedule is enabled ... Make sure SQL Server Agent is running ... Check the logs (Agent and SQL Server) for errors. ... one week ago they all stopped running and they> don't run daily as scheduled at all. ...
    (microsoft.public.sqlserver.dts)