Suddenly the sqlserver express service can't start .... the following message appear when I try to start it:
"the sql server (sqlexpress) service on local computer started and then stopped. some services stop automatically if they have no work to do, for example the performance logs and alerts service "
My OS is win xp SP2 ..... I run sql server loaclly .......
the error log:
2010-04-03 13:11:33.21 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 2010-04-03 13:11:33.25 Server Error: 17054, Severity: 16, State: 1. 2010-04-03 13:11:33.25 Server The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full. 2010-04-03 13:11:33.42 Server (c) 2005 Microsoft Corporation. 2010-04-03 13:11:33.48 Server All rights reserved. 2010-04-03 13:11:33.48 Server Server process ID is 188. 2010-04-03 13:11:33.48 Server Authentication mode
View Complete Post