Author |
Topic |
hong
Starting Member
5 Posts |
Posted - 2006-06-30 : 08:59:55
|
Hi,My SQL Server keeps shutting down. After I restart the computer, it will work, but next morning when I come to the office, the SQL Server is down again.No error for the SQL Server in Event View. This is a part of SQL Log:2006-06-27 08:05:55.43 server SQL Server is ready for client connections2006-06-27 08:06:00.43 spid5 Starting up database 'tempdb'.2006-06-27 08:06:01.09 spid3 Recovery complete.2006-06-27 13:28:08.00 spid51 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'sp_MSgetversion'.2006-06-28 07:25:21.78 server SQL Server terminating because of system shutdown.2006-06-28 07:25:21.78 server LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).2006-06-28 07:25:26.17 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.Thnaks very much for any hlep.Hong |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-30 : 09:25:12
|
It seems that a "device" is not working properly. Could be anything. Could be monitor, network card, mouse, cd/dvd drive.Read Windows Error Log to see what is not functioning properly.Peter LarssonHelsingborg, Sweden |
|
|
hong
Starting Member
5 Posts |
Posted - 2006-06-30 : 10:26:15
|
Hi Peter,The following are some of the Error Logs, but I do not know what they mean.The device, \Device\Scsi\dac2w2k1, did not respond within the timeout period. The open procedure for service "PerfDisk" in DLL "C:\WINNT\system32\perfdisk.dll" has taken longer than the established wait time to complete. There may be a problem with this extensible counter or the service it is collecting data from or the system may have been very busy when this call was attempted. The Spools Services service failed to start due to the following error: The system cannot find the file specified. Windows cannot unload your registry class file. If you have a roaming profile, your settings are not replicated. Contact your administrator. Thanks,Hong |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-30 : 13:53:32
|
It sounds like you've got hardware problems, specifically disk issues. You'll need to correct those in order to fix this problem. Contact your server administrator about this issue.Tara Kizeraka tduggan |
|
|
hong
Starting Member
5 Posts |
Posted - 2006-06-30 : 14:18:09
|
Thanks, Tara |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-07-03 : 02:27:41
|
I suggest you make a full backup of everything you have before your disks die on you.RegardsNThe revolution won't be televised! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-07-03 : 05:20:15
|
It could just be as simple as that the performance monitor file perfdisk.dll is missing. Reinstalling latest service pack might be a good idea.Peter LarssonHelsingborg, Sweden |
|
|
hong
Starting Member
5 Posts |
Posted - 2006-07-04 : 08:00:37
|
I disable one service every day(I pick up one based on the Evnet Viewer Log) and then restart the computer. After I disabled FTP, the SQL Server did not shut down. The following is the Warning Log from Event Viewer:Type: WarningSource: MSFTPSVCThe server was unable to logon the Windows NT account 'Administrator' due to the following error: Logon failure: unknown user name or bad password. The data is the error code. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. Anyone has any idea about this?Thanks,Hong |
|
|
hong
Starting Member
5 Posts |
Posted - 2006-07-04 : 08:03:40
|
Forgot one important thing: the warning log for the MSFTPSVC is logged every second until I disabled the FTP. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-05 : 05:17:17
|
Maybe there is a memory leak in the FTP service when it fails to login? (Which eventually brings the system down, somehow). Or maybe something treats it as a hack-attack and shuts down in self-defense?Kristen |
|
|
|