| Author |
Topic |
|
yaga
Starting Member
8 Posts |
 Posted - 2006-09-26 : 06:19:01
|
| Hi there!!!We got problem on sql server 2k,Sql server stops unknowingly, and all user database has marked as Suspect/Offline,and later on, after sql server stops, all user database has been detached.what is going on???? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-09-26 : 06:23:52
|
| Hardware errors? |
 |
|
|
yaga
Starting Member
8 Posts |
Posted - 2006-09-26 : 06:30:09
|
| I think its not the hardware, it occured also to other pc's upon accessing to and from either machine. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-09-26 : 06:36:17
|
| What does it say in the SQL Server errorlog? What about in the Windows event logs?Paul RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
yaga
Starting Member
8 Posts |
Posted - 2006-09-26 : 06:50:52
|
| These are the logs from sql server--LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).--SQL Server terminating because of system shutdown.--SQL Server is terminating due to 'stop' request from Service Control Manager.From windows event log (descriptions)--The description for Event ID ( 19011 ) in Source ( MSSQLServer ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: (SpnRegister) : Error 1355.--The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 6006, Server shut down by request.And now, the names of databases has change to somewhat like guid format (ex. '7DF74EF3-943A-4269-BD2B-F1B0F2153B12') |
|
|
|
yaga
Starting Member
8 Posts |
Posted - 2006-09-26 : 07:03:10
|
| I got this in event logEvent Type: WarningEvent Source: MSSQLServerEvent Category: (8)Event ID: 19011Date: 9/26/2006Time: 6:42:16 PMUser: N/AComputer: XXXXXDescription:The description for Event ID ( 19011 ) in Source ( MSSQLServer ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: (SpnRegister) : Error 1355. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-09-26 : 07:31:25
|
| ok - you're not giving us enough coherent information and I'm sure you need to get this system running more quickly than you will waiting for random people to respond on the internet. I suggest you call Product Support (www.microsoft.com/support) to help you. Sounds kind of like your disk hardware has dropped out from under you.ThanksPaul RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
yaga
Starting Member
8 Posts |
Posted - 2006-09-26 : 21:10:09
|
Ok thanks. |
|
|
|
yaga
Starting Member
8 Posts |
Posted - 2006-09-26 : 21:18:59
|
Di nyo lang alam eh,hehe |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-09-27 : 00:33:44
|
| Iyo tanong - di bastos kung papayag kayo.Of course, my tagalog is a little rusty...Paul RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
SQL Server Stops unknowingly